Change Value From 1 To Y In MySQL Select Statement
SELECT IF(inty = 1, 'YES', 'No') AS internetApproved FROM Table1
SELECT
CASE
WHEN inty = 0 then 'No'
WHEN inty = 1 then 'Yes'
ELSE 'Maybe'
END
AS InternetApproved
FROM Table1
select case when inty = 0 then 'no' else 'yes' end as newcolname from table1;