Anyone good with MySQL Queries?

[tiger]

I'm trying to write a query and I'm having some problems getting it to do what I want.

I want to compare columnA.commenter_id to all the values in columnB.user_id
if there is no columnA.commenter_id that corresponds to a columnB.user_id
then set columnA.commenter_id to = 999999.

Thanks in advance.

[psili]

UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2
SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL

Sorry. Just lazy and posting from MySQL docs.

[tiger]

Originally Posted by psili

UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2
SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL

Sorry. Just lazy and posting from MySQL docs.

THANK YOU SO MUCH!

I suck at mysql this was taking me forever. I know a few guys that know way more then me and they couldn't do it either.

Big thanks!

[fatfoo]

So you got the answer? Bump if more answers needed.