Hi I have a database with severa

[johno77]

Hi

I have a database with several field including a status field named stat. Could somone please let me know how to change the value of this field i.e. update the stat field to the value approved when say the field called username=john and sex=male.

thanks

 

[sleipnir214]

UPDATE <tablename> SET stat = 'approved'
WHERE username = 'john' and sex = 'male'

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!