Hi there,
What you probably want is
UPDATE temp
SET
QE = CASE WHEN QE = 1 THEN 6 END
QF = CASE WHEN QF = 1 THEN 5 END
WHERE
QA = 1 AND (QE <> 6 OR QF <> 5)
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
Lachlan
-----Original Message-----
From: Mo Li [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 August 2004 9:01 AM
To: [EMAIL PROTECTED]
Subject: Question about case statement
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
