Jump to content

Archived

This topic is now archived and is closed to further replies.

Hokus

Query

Recommended Posts

How can i sellect one value from multible cols ?

 

"SELECT * FROM recipes WHERE category1 OR category2 

OR category3 = \'Appetizers\' ";

 

what query would i use ?

 

Thanks.

Share this post


Link to post
Share on other sites

You can either set up a fulltext index on the 3 columns or

 

\"SELECT * FROM recipes

WHERE (category1 = \'Appetizers\' )

OR (category2 = \'Appetizers\' )

OR (category3 = \'Appetizers\' )\";

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.