Can someone explain why
谁能解释为什么
column LIKE '%board%'
returns more results than
返回的结果比
MATCH (column) AGAINST('board' IN BOOLEAN MODE)
is it because match against ignores words like 'Blackboard', 'Backboard' etc
是不是因为与“黑板”、“篮板”等词语的搭配不当?
Is there away to get MATCH AGAINST return Blackboard, backboard etc?
有客场对阵回传板、篮板等比赛吗?
2 个解决方案
#1
3
MATCH (column) AGAINST('keyword... will match against the literal string provided, where as LIKE "%keyword%" will match if a word contains the string provided.
匹配(列)反对('关键字……将匹配所提供的文字字符串，如果一个词包含所提供的字符串，则与“%关键字%”类似。
#2
0
This should do the trick for you:
这应该对你有用:
MATCH (column) AGAINST('board*' IN BOOLEAN MODE)
Source: http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html
来源:http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html
There are a lot of good examples of search queries there.
那里有很多搜索查询的好例子。
#1
3
MATCH (column) AGAINST('keyword... will match against the literal string provided, where as LIKE "%keyword%" will match if a word contains the string provided.
匹配(列)反对('关键字……将匹配所提供的文字字符串，如果一个词包含所提供的字符串，则与“%关键字%”类似。
#2
0
This should do the trick for you:
这应该对你有用:
MATCH (column) AGAINST('board*' IN BOOLEAN MODE)
Source: http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html
来源:http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html
There are a lot of good examples of search queries there.
那里有很多搜索查询的好例子。