开发者

MySQL Search features such as - and +

Lets say I'm searching the field title, how would I set it up so you could use + and - on keyword开发者_如何转开发s on an SQL level?


Welcome to the world of Full-text searches, especially boolean searches.

Slightly modified example from the manual:

SELECT * FROM articles WHERE MATCH (title) 
AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);

you don't even need to create a FULLTEXT index for these kinds of searches but it is very recommended.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜