全文索引的问题
我在数据库表中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, ' "游记 " ')--去*号