MySQL Forums
Forum List  »  PHP

changing the value of a field if it equals something else
Posted by: AP Fritts
Date: December 21, 2005 07:14PM

Hey!

I have this SQL statement:

UPDATE products SET productid="newValue" WHERE productid="oldValue"

However, this doesn't work...any ideas why?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
changing the value of a field if it equals something else
December 21, 2005 07:14PM


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.