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
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
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 return. And there must be one and only one column
returning