RE: [PHP] Re: sql query question

Hi, 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 <br@benandliz.com> To: php-general@lists.php.net, tony <awardd@essex.ac.uk> 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