Or if you want a more robust method try using MySQL 3.23.23's fulltext indexing search.
Add the following to the end of your table creation or alteration statement.
SQL
FULLTEXT(field1,field2,...)
And then use the Match and against functions in your select query:
SQL
WHERE MATCH (field1,field2,...) AGAINST ('text to search for');
If you want to do binary searches (like the real search engines do you can do it simply with this method (the one below searches for Sam without McKone):
SQL
WHERE MATCH (field1,field2,...) AGAINST ('+Sam -Mckone' IN BOOLEAN MODE);
One small inportant note is that if the phrase you are looking for is found in more than 50% of the rows in your table it will return 0 results to avaid bogging down your server and decrease irrelavent searches...
26 Oct, 2002 - 04:46 PM
| 