SELECT a, b,
CASE WHEN z=1 THEN ‘one’ ELSE ‘TWO’ END c
FROM table