在mysql上进行自定义全文本搜索（创建索引文件）

MySQL

boolean mode

wordbreaker

a fast oburn vixen jmups over an indolent canine

quick
brown
fox
jump
over
lazy
dog

(word, rowid)

word

rowid

PRIMARY KEY

\'+quick +fox\'

rowid

Sphinx

SELECT *, MATCH(field1, field2) AGAINST \'text to search\' 
  IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION AS relevancy 
FROM table1 
WHERE MATCH(field1, field2) AGAINST \'text to search\' 
  IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION
ORDER BY relevancy

UPDATE mytable SET mytable.visa_versa = REVERSE(mytable.myword);

SET @ending = \'end\';
SELECT myword FROM mytable where visa_versa LIKE REVERSE(CONCAT(\'%\',@ending));