CODEWITHSUNDEEP
mysql
G_Coder
G_Coder

Reputation: 51

MySQL Wildcard strict words occurance search

I have problem with MySQL Wildcard search. What i am try to achieve is - wildcard search but it should be very strict about the words occurrence.

For example : i want to search the word "Science", it will bring out all the word that have Science on it, but it will restrict from bringing out close words like Score, scrabber, etc.

I need help please, thank you in advance.

Upvotes: 0

Views: 99

Answers (1)

Itay Moav -Malimovka
Itay Moav -Malimovka

Reputation: 53603

read aboud soundex levenstein and metaphone string functions. Here is a start http://forums.mysql.com/read.php?20,199681,199681#msg-199681

Besides, I believe SOLR would be a better candidate for such search.

Upvotes: 0

Related Questions