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
    ...