Is there some kind of workaround that would make it possible to achieve the equivalent of Oracle's DECODE function in a MySQL query? Or could it be done through some convoluted PHP code?
I'm trying to return all rows from a table 'members', with the following values:
The columns 'active' and 'admin' hold the value 1 or 0 to show the member's status.
I want to return 'Yes' or 'No' instead, for usability reasons.