On Mon, 2010-10-04 at 19:32, Deryck Henson wrote: > The original query is as follows: > > SELECT * FROM websites WHERE category LIKE '%"&search&"%' OR keywords LIKE > '%"&search&"%' OR description LIKE '%"&search&"%' > > The "&search&" instances are from an ASP page. 'search' is a variable that > is asigned the value of the query string 'search'
Searches with LIKE expression are not effective. Go to http://www.mysql.com and search for keyword "fulltext". MySQL supports fulltext indexes which are made for this purpose. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
