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