On Thu, 2007-07-05 at 22:26 -0400, Nathan Nobbe wrote: > Kevin, > > just like Daniel said, > > $sql .= "OR product_description *LIKE '%".$terms."%'"*; > > most of the *search engines* ive seen revolve around the use of the LIKE > construct<http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#operator_like> > which is a simplified regex mechanism for an SQL query [for MySQL at least, > probly other RDBMS' as well]
Don't do that. Unless you have a teency weency set of data don't use LIKE syntax to match data. It's extremely inefficient and requires scanning the entire table. If you need to use MySQL use the MATCH AGAINST syntax since it will index the data and search much faster. I've heard tell it sucks beyond a certain size, but it's great for quick solutions and moderate sized data. If you need something more powerful look into something like Lucene. Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
