MySQL匹配多个值以再次匹配 [英] MySQL Match Against with Multiple Values to AGAINST

问题描述

我认为这是一个非常简单的查询，但是我在任何编程书籍中或网上都找不到.

I think this is a very simple query but I just can't find it in any of my programming books or on the net.

我有这个查询: SELECT * FROM test WHERE MATCH(column1，column2)AGAINST('value1');

I have this query: SELECT * FROM test WHERE MATCH (column1,column2) AGAINST ('value1');

但是我需要AGAINST具有多个值，例如(值1，值2，值3)

But I need AGAINST to have multiple values e.g. (value1,value2,value3)

任何人都可以帮忙吗?

推荐答案

我认为布尔模式修饰符可能就是您想要的.

I think the BOOLEAN MODE modifier might be what you are looking for.

SELECT * FROM test WHERE MATCH (column1,column2) 
     AGAINST ('+value1 +value2 +value3' IN BOOLEAN MODE);

这篇关于MySQL匹配多个值以再次匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！