MYsql: How to rename

Hi All

I add a new value to a table as below

Insert into hcl (category,detail,priority) VALUES ('project','test1','p1');

Now I need to rename "test1" to a new name "value1" so can some one tell me how can I rename the value.

BTW, I am using MySQL Query Browser to run queries.

Thanks
Tannu

See UPDATE syntax.

Also, going over an SQL tutorial probably ain't a bad idea too.

Thank you.