select * from jgdmaterial where match (author) against ('david');
能够查询到记录,而
select * from jgdmaterial where match (author) against ('avid');
就查询不到记录?我想匹配任意一个单词或者单词的一部分怎么做?谢谢。
能够查询到记录,而
select * from jgdmaterial where match (author) against ('avid');
就查询不到记录?我想匹配任意一个单词或者单词的一部分怎么做?谢谢。
[sql]WHERE MATCH(author) AGAINST('avid*' IN BOOLEAN MODE);
WHERE MATCH(author) AGAINST('*avid' IN BOOLEAN MODE);
WHERE MATCH(author) AGAINST('*avid*' IN BOOLEAN MODE);[/sql]