MySQL Fulltext Search with Multiple Tables
Posted on 2010-11-21
Hi, I'm trying to write a search query. I'm trying to take advantage of the "Natural Language" search capability.
Here is my query:
SELECT person.personid, person.firstname, person.lastname, facility.name, state.stateLongName, detail.description
LEFT JOIN facility ON person.facility = facility.facilityid
LEFT JOIN detail ON person.personid = detail.personid
LEFT JOIN state ON facility.state = state.stateID
MATCH (person.firstname, person.lastname, facility.name, state.stateLongName, detail.description)
I have FULLTEXT indexes set up on each of the columns in the MATCH part of the query.
I get the following error:
#1210 - Incorrect arguments to MATCH
Any thoughts on what I'm doing wrong? I'm using MySQL 5.0.