case syntax

[Bob Bedford]

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

[Alvaro G Vicario]

*** 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
--

[Dave]

Bob Bedford (be******@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 <da**@REMOVEbundook.com>
(Remove REMOVE for email address)

[Dave]

Dave (da**@REMOVEbundook.com) decided we needed to hear...

Bob Bedford (be******@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 <da**@REMOVEbundook.com>
(Remove REMOVE for email address)