using phpMyAdmin sql to selectively update fields

I'm trying to update selective fields using sql in phpmyadmin

something like this

update 'recipes' when category = wings set bookimage = "wings.gif"

Can't seem to understand all the help stuff and get it to work.

thks

 

update 'recipes' set bookimage = "wings.gif" where category = "wings"

 

What rosytoes said but just to add, you might want to go 'Operations' and copy a backup of the lot first.

 

I made adjustment for exact. other than that I posted exactly but get this error still.
Thks though

Error

SQL query:

UPDATE 'recipes' SET bookimage = "wings.gif" WHERE category2 = "Chicken Wings"

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''recipes' set bookimage = "wings.gif" where category2 = "Chicke

 

the quotes on either side of recipes are a double and a single? either loose the quotes all together or use the `. It is the key to the left of the number one key on my keyboard.

 

Excellant. THe backward quote did it. How can you know which one to use? Just trial and error?

 

afaik, the backward quote is only used for table names, I always use single or double quotes for strings or variable names.