感谢楼上2位,就是不知道这是怎么计算的?如何拆分主标题,检索相似度高的标题?比如:上部分标题:Watch the brand new trailer for The Twilight Saga.数据表:+------+-------------------------------------------------------+ | id | title | +------+-------------------------------------------------------+ | 1 | Watch the brand new trailer for The Twilight Saga. | +------+-------------------------------------------------------+ | 2 | Twilight New Moon Eclipse Breaking Dawn. | +------+-------------------------------------------------------+ | 3 | Batman is a fictional character. | +------+-------------------------------------------------------+ | 4 | The bestselling graphic novel adaptation of the | | | Twilight Saga continues with New Moon. | +------+-------------------------------------------------------+查询语句是什么?肯定不会是split每一个单词,逐字进行全文查询。
| id | title |
+------+-------------------------------------------------------+
| 1 | Watch the brand new trailer for The Twilight Saga. |
+------+-------------------------------------------------------+
| 2 | Twilight New Moon Eclipse Breaking Dawn. |
+------+-------------------------------------------------------+
| 3 | Batman is a fictional character. |
+------+-------------------------------------------------------+
| 4 | The bestselling graphic novel adaptation of the |
| | Twilight Saga continues with New Moon. |
+------+-------------------------------------------------------+查询语句是什么?肯定不会是split每一个单词,逐字进行全文查询。
有没有相关FUNCTION或者教程?