To:
Sent: Sunday, January 15, 2006 10:21 AM
Subject: A difficult query- urgent for me
Dear Friends,
I have a problm, try to solve that.
Actually there is a table with columns a and b .
So i want if a contains a particular word than a's value should return else
'b' value should re
On 1/15/06, [EMAIL PROTECTED] wrote:
>
> Actually there is a table with columns a and b .
> So i want if a contains a particular word than a's value should return else
> 'b' value should return.
SELECT
CASE
WHEN a = 'Good' THEN a
ELSE b
END
FROM
table
Jochem
Dear Friends,
I have a problm, try to solve that.
Actually there is a table with columns a and b .
So i want if a contains a particular word than a's value should return else
'b' value should return. And there must be one and only one column
returning. I have mysql 4.x and i think the logic will be