Yes, easily. Use the 'if' conditional in mysql...
select if(col_name = 1, 'yes', 'no') from table_name;
"Shaun" <[EMAIL PROTECTED]>
09/03/2003 10:32 AM
[PHP-DB] Viewing Data From MySQL
Is it possible to change the way a query is displayed from a MySQL
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