mysql query -- need some help.

[cobradude]

I need to find in the "user" table IF field blah is set to "1" then set field blah2 to "1".

What is the sql statement I need to do this?

Thanks for your help.

[cobradude]

Anyone?

[Paul M]

update user set blah2 = 1 where blah = 1;