Returning a field as a custom value can be done one of two ways:

```sql
-- IF Method example:
SELECT
    table.id,
    IF( table.column > 0, 'Yes', 'No' ) AS column
    ...
```

```sql
-- CASE Method example:
SELECT
    table.id,
    CASE table.column WHEN '0' THEN 'No' ELSE 'Yes' END
    ...
```