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