Advertisement
Guest User

Untitled

a guest
Feb 18th, 2013
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. UPDATE wp_rg_lead_detail
  2. SET value = CASE ROUND( field_number*10 )
  3. WHEN 383 THEN 'johnsmith'
  4. WHEN 386 THEN 'john@example.com'
  5. WHEN 388 THEN 'California'
  6. END
  7. WHERE form_id = 3 AND lead_id = 1 AND ROUND( field_number*10 ) IN ( 383, 386, 388)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement