Help with MySql INSERT Statement

[mrvolleyball]

Any MySql gurus out there ?

I'm trying to INSERT some values into specific records in a table

OR to look at it another way:
I want to check to see if a column has a value of '0' if it does change this value to '1'

Any thoughts ?

 

[joe]

UPDATE table SET key = '1' WHERE key = '0';

 

[kyleirwin]

http://www.w3schools.com/sql/sql_update.asp

There are tons of great basic tutorials on that site that I use all the time when I need code for reference.

 

[mrvolleyball]

Ahh, UPDATE - had forgotten about that one.
Thanks very much Joe, and thanks for the link Kyle it looks very useful.