Hello, I'm trying to update table by using case statement. I used following syntax: UPDATE temp SET CASE WHEN QE = 1 THEN QE = 6 WHEN QF = 1 THEN QF = 5 END WHERE QA = 1 AND ( QE != 6 OR QF !=5) but it didn't work. I checked the manual and didn't see where is the problem. Thanks for any help.
__________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]