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]
