FN-FORUM: simple php my admin mySql query qustion?

date posted 23rd August 2004 09:47

only just starting useing mySql but what i want to do is
set a field called "group" to "yes" where ever the fields
"rider_number" = 0 and "bike_color" = "" (empty string)

i guess i would it would be some thing along these lines

UPDATE group='yes' WHERE 'rider_number' = 0 and 'bike_color' = ""

i what to write this in the sql window in php my admin

this did not work

have nice monday

kev