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
