CODEWITHSUNDEEP
mysqlfull-text-search
sandeep.mishra
sandeep.mishra

Reputation: 825

mysql partial word searching

I want to search like the below query but it is not working in MySQL

 SELECT * FROM products WHERE MATCH (title,description) 
 AGAINST ('test' IN BOOLEAN MODE);

I want below output

testproduct, producttest

Can anybody help me on this..?

Upvotes: 19

Views: 18077

Answers (2)

andrewchan2022
andrewchan2022

Reputation: 5290

currently, only support prefix, not support suffix:

SELECT * FROM products WHERE MATCH (title,description) 
 AGAINST ('test*' IN BOOLEAN MODE);

http://dev.mysql.com/doc/refman/4.1/en/fulltext-boolean.html

By the way, MySQL full text search will be bottleneck when the website request is large, and it is vulnerable and unstable for some special search word, thus often lead to slow query and database crash. Use Elastic Search as soon as possible.

Upvotes: 36

Billy
Billy

Reputation: 788

Use LOCATE instead... or better yet, use Lucene and forget MySQL for searches.

Upvotes: -6

Related Questions