0

I have mysql table containing about lots of names of songs. I want to create smart search, so that i can find specific song from name. it should return then smart search result like google does. (not as perfect as google) I need spell mistake avoidance and ranking according to relevance.

is there any easy way to do this?

Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
minal dube
  • 11
  • 1
  • 4
  • This is going to get closed. Still, you should look up `FULLTEXT` search. – O. Jones Nov 29 '16 at 18:53
  • i tried full text but it does not full fill my requirements – minal dube Nov 29 '16 at 19:08
  • Welcome to StackOverflow! This is a very broad question, to find a solution you should try to seperate the problems. A question about [spelling errors](http://stackoverflow.com/questions/7200935/best-way-to-deal-with-misspellings-in-a-mysql-fulltext-search) in mysql exists already. – ventiseis Nov 29 '16 at 22:02

0 Answers0