Changing the output of a SELECT statement 1

[LaundroMat]

Is it possible in MySQL to do something like this:

SELECT option FROM table
IF option = TRUE return "Yes" else return "No"

In other words, would it be possible to issue a select statement that returns Yes'es and No's, instead of 0 and 1's?

 

[sleipnir214]

Use the if() function:

SELECT if(option = 1, 'Yes', 'No') from tablename

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[LaundroMat]

Thanks!