Guest User

Untitled

a guest
Feb 18th, 2013
63
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data