[SOLVED] ENUM

[jaymc]

I have an ENUM field of either 1, 0.

 

However really I want to show 1 as Yes and 0 as No. How can I make it output it as Yes/No even though I store it as 1/0

 

This must be done in the query, no php str_replace etc.

[rhodesa]

Why must it be done in the query?

 

Try this:

SELECT (CASE fieldName WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' ELSE 'No' END) FROM tableName

[jaymc]

Cheers, Worked