|
|
Posted by Bob Bedford on 10/01/54 11:16
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
Navigation:
[Reply to this message]
|