ent: Wednesday, November 12, 2003 4:54 PM
> To: [EMAIL PROTECTED]
> Subject: Equivalent Function Needed
>
>
> I use the following function in Oracle
> SELECT decode(status,'A','Active','L','Active','Former') FROM Table
>
&g
I use the following function in Oracle
SELECT decode(status,'A','Active','L','Active','Former') FROM Table
What it means is: if table column status = A, return "Active", if status=L, return
"Active", else return "Former" in the select statement.
Decode in mysql has nothing to do with this functio
