Returning a field as a custom value can be done one of two ways:
-- IF Method example:
SELECT
table.id,
IF( table.column > 0, 'Yes', 'No' ) AS column
...
-- CASE Method example:
SELECT
table.id,
CASE table.column WHEN '0' THEN 'No' ELSE 'Yes' END
...