Easiest way to do, use if-else and convert it to desired string!!
--
Regards,
--Balaji
On Wed, 3 Sep 2003, Shaun wrote:
Hi,
Is it possible to change the way a query is displayed from a MySQL database.
For example if I have a column that contains '1' or '0' can I run a query
that returns
Hi,
Is it possible to change the way a query is displayed from a MySQL database.
For example if I have a column that contains '1' or '0' can I run a query
that returns 'Yes' for every '1' and 'No' for every '0'?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To
Yes, easily. Use the 'if' conditional in mysql...
select if(col_name = 1, 'yes', 'no') from table_name;
David
Shaun [EMAIL PROTECTED]
09/03/2003 10:32 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
[PHP-DB] Viewing Data From MySQL
Hi,
Is it possible to change the way a query