get values from table1 match the agaist table2 and if date exist in both table update Enum filed with 1 where table1.row = table2.row is that posible or do i make self clear?
+1
A:
You're going to be looking for a join query (inner, outer, left etc.) however you haven't provided enough information. The structure of both tables and some example data and example results are a good start :)
Ross
2010-09-06 20:51:21
ok i have a table1 containing a fieldset with emails and is constantly adding up via cron jobs now there is tabel2 that has the same emails. now i need to update table2 field "status" (wich is an enum field) where email on table1 = email on table2
Bruce
2010-09-06 21:07:22
A:
I think you want something like this:
UPDATE table2 SET status = 1 WHERE email IN (
SELECT email FROM table1 WHERE foo = 'bar
);
Yorirou
2010-09-06 21:23:36