Hello Mark and John,
Mark Goodge wrote:
John Furlong wrote:
My question is, can the argument in AGAINST() refer to a column in
another table or does it have to be a specific string you are
searching for? If the MATCH() function won't work, any suggestions
on how else to compare table1.name ag
You may be able to get what you need with three queries. Join the tables on
the column of interest. By default you'll get a list of the matches. Then
you can modify the join by adding a WHERE clause that looks for
table2.nameis null, and again by modifying the WHERE clause so it
looks for
table1.na
John Furlong wrote:
My question is, can the argument in AGAINST() refer to a column in
another table or does it have to be a specific string you are
searching for? If the MATCH() function won't work, any suggestions
on how else to compare table1.name against table2.name? The columns
are defined
I have about 120,000 organization names in table1 which I am trying to match
against 75,000 organization names in table2 and see if they are a perfect
match, a partial match or don't match at all.
I was looking at Natural Language Full Text Searches,
(http://dev.mysql.com/doc/refman/5.0/en/ful
