Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Query with match against another table field...

gnagnognagno EntrantCurrent User Role Beginner
Hello all,

I have this situation:

Table A
strings
id int
string varchar(255)

Table B
cities
id int
name varchar(255)

I need to compare all the city names with the strings in Table A to find in which strings the name of the cities are:

I was trying to make something like:

SELECT * FROM strings, cities WHERE match(strings.string) against (cities.name);</pre>


but I get:
ERROR 1210 (HY000): Incorrect arguments to AGAINST</pre>



do you have any suggestion?

Thank you in advance
Gnagno
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.