Re: [PHP-DB] Viewing Data From MySQL
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 'Yes' for every '1' and 'No' for every '0'? > > Thanks for your help > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Viewing Data From MySQL
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 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 unsubscribe, visit: http://www.php.net/unsub.php