Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
mysql MATCH to find best name matches in two fields
Ok, so I kinda answered my own question here. It seems the AGAINST() function can only accept constant values, and not something like fields. So, while I wanted a purely database operation here, I'll have to write a loop in someother language and iterate through the values in a field. For this... -
mysql MATCH to find best name matches in two fields
This seems to be a derivation of a question that I've seen quite a bit in my quest. Here it is: I'm trying to use the mysql MATCH function to identify the best matching names between two lists stored in two fields in two tables. I think this can be done, but my logic engine is failing me. The...
