I have roughly 500 records that I need to update in my table. I want to take my original table named "mytable" and update the value in the column "dev" to the value in the column "dev" of the second table "newtable". The updated will take place when the email in "newtable" matches and email in the "mytable"
Here is it written out another way
Original Table - mytable
Email Dev
example@example.com YES
Second Table - newtable
Email Dev
example@example.com Need this value
I tried this but it doesn't work as it doesn't see the second table
UPDATE table SET 'column' = 'O' WHERE email IN (SELECT email FROM table2)