Equivalent function?

[Jon]

I use the following function in Oracle
SELEC T decode(status,'A','Active','L','Active','Former') FROM Table

What it means is: if 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 functionality and I didnt see a
function while browsing the docs online that did this. Is there an
equivalent function in mySQL?

Thanks

--
********************************
Jon Rosenberg
www.DeanForAmerica.com
www.OhioForDean.org