USE INDEX issue in full text search[RESOLVED]

[Paul Allsopp]

I am getting what seems to be a syntax/parse error in this query on the USE INDEX

=================================================================================
SELECT SQL_CALC_FOUND_ROWS `ID`, `Sandy_ID`, `DESCRIPTION`, `URL`, `PHONE_NUMBER`, `ADDRESS`, `CITY`, `STATE`, `ZIP`, `TITLE`,
MATCH(`TITLE`, `DESCRIPTION`, `META_KEYWORDS`, `META_DESCRIPTION`)
AGAINST('(+something +missing) ("on the day") (born birthed hatched found) (-mother -father -sister -brother)') as `relevance`
FROM
(
SELECT *
FROM `PLD_LINK`
WHERE `CITY` = 'Pasadena'
AND (`STATE` = 'CA' OR `STATE` = 'California')
) USE INDEX ( advSearch )
HAVING `relevance` > 0.001
ORDER BY `relevance` DESC
LIMIT 0, 6
=================================================================================

I am having to use USE INDEX because without it I am told MySQL "Can't find FULL TEXT index matching the column list", even though I clearly have a FULL TEXT index on the pld_link table with those 4 columns in it.

Any thoughts?

Thanks,
Paul



Edited 1 time(s). Last edit at 05/08/2009 12:56PM by Paul Allsopp.