开发者

fulltext and INT columns integer the same query

开发者 https://www.devze.com 2023-04-05 16:44 出处:网络
I have a fulltext index on column Title. But the query contains additional \"AND\" condition where an integer column 开发者_如何学运维\"CategoryID\" with index is involved.

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

精彩评论

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