Skip to content

Instantly share code, notes, and snippets.

@iso100

iso100/sql update

Created March 10, 2014 15:03
Show Gist options
  • Save iso100/9466667 to your computer and use it in GitHub Desktop.
Save iso100/9466667 to your computer and use it in GitHub Desktop.
Download ZIP
Update field based on match on fields in temp table
Raw
sql update
UPDATE exp_pw_landingpages epw
SET epw.mailcode =
(SELECT mailcode FROM temp WHERE website = epw.website and subdir = epw.subdir)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment