oops, I found what was my mistake. I copied and paste a line to write the
command for you but I forgot to remove CASE :) so write your query like
this:
SELECT
CASE WHEN status IN('BR', 'VQ', 'RQ', 'NG' )
THEN
'binding'
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' )));
----- Original Message -----
From: "Mojtaba Faridzad" <[EMAIL PROTECTED]>
To: "Chris Boget" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 3:43 PM
Subject: Re: Case statement
> 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]
