Hi All
Is there any function in mysql which acts similar like decode() in Oracle..
The decode function acts like a procedural case statement inside a single
SQL statment to return different values or columns based on the the values
of other columns in the select statement.
It is extremely
Have a look below:
--
If expr1 is TRUE (expr1 0 and expr1 NULL) then IF() returns expr2,
else it returns expr3. IF() returns a numeric or string value, depending on
the context in which it is used:
mysql select IF(12,2,3);
- 3
mysql select IF(12,'yes','no');
-
Thanx Lewis..It worked
- Original Message -
From: Neville Lewis [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 12:34 PM
Subject: RE: Alternative to decode() in Oracle
Have a look below:
--
If expr1 is TRUE (expr1 0 and expr1 NULL