Overwrite/change values in row

[ejoeyz]

I have a mysql db with a table for user comments, values are:
id,name,date,entry,approve

I want to later go back and have a function overwrite a specific users comment, but only the 'approve' field. My primary key is id, so is there a way to specify which row and field to overwrite/change the value?

[ahundiak]

UPDATE table_name SET approve = 'Nope' WHERE id = 666;

Might want to spend some time with the mysql manual.