It is better to use FullText. Convert the description field to FullText. You will gain a powerfull control in this case. For more information on how to use FullText read a little-bit in the MySql manual (MATCH AGAINST) commands.
Regards, Hamid Hossain
----------------------- Check Amazon.com Latest PHP books: http://www.amazon.com/exec/obidos/redirect?tag=zawraqclassif-20&path=tg/browse/-/295223
Start Accepting CreditCard at your site in minutes: http://www.2checkout.com/cgi-bin/aff.2c?affid=106720
Download Alexa Tool Bar to stop Pop-ups for FREE: http://download.alexa.com/?amzn_id=zawraqclassif-20
Download Ready-Made Templates for your site: http://www.aplustemplates.com/cgi/affiliates/c1.cgi/zawraq_ad
----Original Message Follows---- From: Ben Ramsey <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], tony <[EMAIL PROTECTED]> Subject: [PHP] Re: sql query question Date: Thu, 12 Feb 2004 16:05:16 -0500
This is a SQL question, rather than a PHP question, so I would suggest doing a google search on SQL tutorials, but I think what you are trying to do would work like this:
SELECT * FROM table WHERE descript LIKE '%new%' OR descript LIKE '%car%'
Tony wrote:
hi
if i have new car and i want to search each word in description can i do SELECT * FROM table WHERE descript = "new" OR descript ="car"??
any help is appreciated
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php