MySQL Forums
Forum List  »  Newbie

Easy problem, just need a query (syntax)
Posted by: Jake Russell
Date: August 16, 2005 03:50PM

Hi folks -

I don't do manual queries often (and when I do, it's usually just a slightly edited version of something written by somebody else) so I'm a little stumped... In short, I need to take all my Spanish jokes and change the value of the field "lang" (varchar) to "Spanish" where "c_id = 60" (category id).

I'm on the right track, but I don't know the command to get it done, and I don't want to start "experimenting" with my live DB. ;)

I'm looking for something along this line:

I want to change all occurrances of
lang = Spanish

WHERE
c_id = 60

Would someone please be so kind as to write this out properly for me? (I'm using PhpMyAdmin, so I just need the raw query.)

Thank you!

Options: ReplyQuote


Subject
Written By
Posted
Easy problem, just need a query (syntax)
August 16, 2005 03:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.