Results 1 to 1 of 1
Thread: MySQL's FULLTEXT search
Jul 19, 2001, 17:22 #1
- Join Date
- Sep 2000
- 0 Post(s)
- 0 Thread(s)
MySQL's FULLTEXT search
Just discovered this feature on a website that uses it for its internal search engine, played with it for a little while, and am enchanted by it
Instead of building your search engine with tons of LIKE statements, you can just add a WHERE statement. Example:
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('PHP content management system');
would select all the articles that deal with it, with the results being sorted by relevance, first result being the most relevant, and so on.
Anyone using that cool built-in functionnality ?