best match query

[happykiran]

Hi,

I want to know how to exctract the rows that best match the given string.

Eg: My String is 'harrypotter', and in the table, I have got the following values

select names from students;

Names
------------
harry
harrypot
someoneelse
harest
harryp

Among them, I would like to extract 'harrypot', which is the best match

Can someone explain how this could be achieved ?

Thanks in adv.
Kiran.

 

[QatQat]

http://www.mysql.com/doc/en/Fulltext_Search.html

This should help you.


Bye

Qatqat

Life is what happens when you are making other plans.