全文索引的问题
我在数据库表中title字段输入＂西游记＂
select * from TDocument where freetext(title, ' "西* " ')
能查到数据
select * from TDocument where freetext(title, ' "西游记 " ')
也能查到
select * from TDocument where freetext(title, ' "*游* " ')
或
select * from TDocument where freetext(title, ' "*游记 " ')
或
select * from TDocument where freetext(title, ' "*记 " ')
就查不到不知道是为什么
[解决办法]
select * from TDocument where contains(title, ' "*游* " ')
这看过这样的用法
select * from TDocument where contains(title, ' "游 " ')--去*号
select * from TDocument where contains(title, ' "游记 " ')--去*号
