57.笔记 MySQL学习——查询扩展全文搜索
开展扩展全文搜索,需要在字符串后面加上WITH QUERY EXPANSION。
如下:
mysql> select * from apothegm wherematch(attribution,phrase) against('bell book');
+-----------------------+------------------------------------+
| attribution | phrase |
+-----------------------+------------------------------------+
| Miguel de Cervantes | Bell, book, and candle |
| Alexander Graham Bell | Mr. Watson, comehere. I want you! |
+-----------------------+------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from apothegm wherematch(attribution,phrase) against('bell book' with query expansion);
+-----------------------+---------------------------------------+
| attribution | phrase |
+-----------------------+---------------------------------------+
| Miguel de Cervantes | Bell, book, and candle |
| Alexander Graham Bell | Mr. Watson, comehere. I want you! |
| Robert Burton | I light my candle from theirtorches. |
+-----------------------+---------------------------------------+
3 rows in set (0.00 sec)
第一条查询查询命令展示的是一次自然语言搜索。
第二条语言查询命令展示的是一次查询扩展搜索。多找到了一行记录,而它并没有包含原始搜索字符串里的那些单词。之所以能找到,因为包含单词candle,而这个单词存在于那个自然语言搜索锁找到的行里。