case syntax

Hi,

I've no Mysql NG access from my ISP, so let me ask here.

I've a case statement in mysql.

Here is the code:

select ....,
case myvalue
when 'X' then valueX
when 'Y' then valueY
when 'A' then valueY
when 'B' then valueY

In my case, Y,A and B gave the same value.

I'm trying to do something like:

case myvalue
when 'X' then valueX
when in('Y','A','B') then valueY

But I can't get it to work with IN statement. What's the syntax ?

Bob

*** Bob Bedford wrote/escribió (Thu, 19 May 2005 08:30:54 +0200):
> case myvalue
> when 'X' then valueX
> when in('Y','A','B') then valueY
>
> But I can't get it to work with IN statement. What's the syntax ?

This is the syntax for CASE:

http://dev.mysql.com/doc/mysql/en/ca...t.html#IDX1957
http://dev.mysql.com/doc/mysql/en/co...s.html#IDX1232


--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--

Bob Bedford (bedford1@notforspammershotmail.com) decided we needed to
hear...
> Hi,
>
> I've no Mysql NG access from my ISP, so let me ask here.
>
> I've a case statement in mysql.
.....
> I'm trying to do something like:
>
> case myvalue
> when 'X' then valueX
> when in('Y','A','B') then valueY
>
> But I can't get it to work with IN statement. What's the syntax ?
>
> Bob
>
>
select case when myvalue = 'X' then valueX
when myvalue in ('Y','A','B') then valueY else 'something'

If you don't supply the trailing else then null will be returned if
none of the conditions are satisfied.
--
Dave <dave@REMOVEbundook.com>
(Remove REMOVE for email address)

Dave (dave@REMOVEbundook.com) decided we needed to hear...
> Bob Bedford (bedford1@notforspammershotmail.com) decided we needed to
> hear...
> > Hi,
> >
> > I've no Mysql NG access from my ISP, so let me ask here.
> >
> > I've a case statement in mysql.
> ....
> > I'm trying to do something like:
> >
> > case myvalue
> > when 'X' then valueX
> > when in('Y','A','B') then valueY
> >
> > But I can't get it to work with IN statement. What's the syntax ?
> >
> > Bob
> >
> >
> select case when myvalue = 'X' then valueX
> when myvalue in ('Y','A','B') then valueY else 'something'
>
> If you don't supply the trailing else then null will be returned if
> none of the conditions are satisfied.
>
My apologies - I'm missing an end from the statement...

select case when myvalue = 'X' then valueX
when myvalue in ('Y','A','B') then valueY else 'something' end

--
Dave <dave@REMOVEbundook.com>
(Remove REMOVE for email address)