SQL How to replace values of select return?

Question

In my database (MySQL) table, has a column with 1 and 0 for represent true and false respectively.

But in SELECT, I need it replace for true or false for printing in a GridView.

How to I make my SELECT query to do this?

In my current table:

 id   |  name    |  hide   1   |  Paul    |  1   2   |  John    |  0   3   |  Jessica |  1 

I need it show thereby:

  id  |  name    |  hide   1   |  Paul    |  true   2   |  John    |  false   3   |  Jessica |  true 

Answer 1

You have a number of choices:

1. Join with a domain table with TRUE, FALSE Boolean value.

2. Use (as pointed in this answer)

   SELECT CASE WHEN hide = 0 THEN FALSE ELSE TRUE END FROM 

   Or if Boolean is not supported:

   SELECT CASE WHEN hide = 0 THEN 'false' ELSE 'true' END FROM 

Answer 2

I got the solution

   SELECT     CASE status       WHEN 'VS' THEN 'validated by subsidiary'       WHEN 'NA' THEN 'not acceptable'       WHEN 'D'  THEN 'delisted'       ELSE 'validated'    END AS STATUS    FROM SUPP_STATUS 

This is using the CASE This is another to manipulate the selected value for more that two options.