Re: [PHP-DB] Viewing Data From MySQL

2003-09-04 Thread Balaji H. Kasal 

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

2003-09-03 Thread dpgirago 
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

[PHP-DB] Viewing Data From MySQL

2003-09-03 Thread Shaun 
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