MySQL Forums
Forum List  »  Full-Text Search

USE INDEX issue in full text search[RESOLVED]
Posted by: Paul Allsopp
Date: May 06, 2009 02:04PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
USE INDEX issue in full text search[RESOLVED]
4746
May 06, 2009 02:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.