Posted by Bob Bedford on 07/20/05 15:10

I don't have mysql Newsgroup access so let me try here.

I've to find in a table the "closer" result given some text.

Here is a little example:

given the text "Batman socks" I've to find the best matching result in
choices like:
-"mickey socks"
-"robin socks"
-"batman black socks" ->this should be found
-"batman wallet"
-"batman"

or given the text "leather shoes" I've to find the best matching result in
choices like:
-"socks"
-"shoes" ->this should be found
-"pants"
-"shirts"
-"leather wallet"

My problem is to get the best choice where I've too many informations in the
given text.
I mean using - like '%Batman%' and like '%socks%'- will work for the first
case, but not the second.

Any idea ?

Bob

[Back to original message]