I didn't have your table so I tried to write the same command by one of my
tables. my query which worked, is:
SELECT CASE WHEN left( workorder, 1 )
IN ( 'C', 'T' )
THEN 'group1'
WHEN left( workorder, 1 )
IN ( '3', 'R' )
THEN 'gorup2'
ELSE
'group3'
END FROM workfile;
----- Original Message -----
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "Mojtaba Faridzad" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 3:34 PM
Subject: Re: Case statement
> > SELECT
> > CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' )
> > THEN
> > 'binding'
> > CASE WHEN status IN('NA', 'NG', 'RA')
> > END as action
> > FROM master_info WHERE
> > (( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR
> > ( status IN ( 'NA', 'NG', 'RA' )));
>
> Sadly, that didn't work:
>
> Your MySQL connection id is 208517 to server version: 4.0.14-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> SELECT
> -> CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' )
> -> THEN
> -> 'binding'
> -> CASE WHEN status IN('NA', 'NG', 'RA')
> -> END as action
> -> FROM master_info WHERE
> -> (( status IN ( 'BR', 'VQ', 'RQ', 'NG' )) OR
> -> ( status IN ( 'NA', 'NG', 'RA' )));
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
'CASE
> WHEN status IN('NA', 'NG', 'RA') END as action FROM master
>
> Do you have something similar that works? What does it look like?
>
> Chris
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
