I have a fulltext index on column Title
. But the query contains additional "AND" condition where an integer column 开发者_如何学运维"CategoryID" with index is involved.
What is the best solution for this situation? This query just use fulltext index but I want this query to use fulltext + integert column index
SELECT *
FROM News
WHERE MATCH(Title) AGAINST('value')
AND CategoryID=1
精彩评论