开发者

fulltext and INT columns integer the same query

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜