how to search a column in MySQL (return boolean)

[cowmunchies]

trying to search a column in MySQL and returning a boolean result. How do I do this?

Like say search for $string=mice in column='food' of table 'dog'.

[Fumigator]

You won't get a boolean result back, but you can "force" a boolean result by checking the number of rows your query returns and if it's > 0 then return "true".

Or are you asking what the syntax is for the query?

http://dev.mysql.com/doc/refman/4.1/en/select.html

[lli2k5]

thanks I got it. You're right. Just check the result and execute based on the mysql_num_rows command.