Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE wp_rg_lead_detail
- SET value = CASE ROUND( field_number*10 )
- WHEN 383 THEN 'johnsmith'
- WHEN 386 THEN 'john@example.com'
- WHEN 388 THEN 'California'
- END
- 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