Why does not USE INDEX work with MATCH ... AGAINST?

[Tore Krudtaa]

Hi.

Have the following table.

text

with these fields

ID1
ID2
Text

Primary key: ID1 and ID2
Fulltext index: Text (named Text)

Executing the following query in PhpMyAdmin returns an empty window with no errors, and no query string....

SELECT ID1, ID2, Text
FROM text use index (Text)
WHERE
MATCH (Text)
AGAINST ('+luminous' IN BOOLEAN MODE)
AND ID1=1

If I remove the "use index (Text)" from the query then it works, but it is not using
the fulltext index, but the primary index.

I want to search the table using the fulltext index but I also only want records where ID1=1 returned, and I want to use the fulltext index and not the primary key.

What I'm I doing wrong here.....

Anybody