mysql> SELECT text FROM table; +-------------------------------------------------------+ | text | +-------------------------------------------------------+ | vörvaň prostý | | lezevec prostý | | lezevec obecný | | jezevec obecný | | jezevec žlutý | | vorvaň prostý | | vorvan prostý | +-------------------------------------------------------+ 8 rows in set (0.00 sec) mysql> SELECT text, MATCH (text) AGAINST ('vorvan') AS rel FROM table; +-------------------------------------------------------+------+ | text | rel | +-------------------------------------------------------+------+ | vörvaň prostý | 0 | | lezevec prostý | 0 | | lezevec obecný | 0 | | jezevec obecný | 0 | | jezevec žlutý | 0 | | vorvaň prostý | 0 | | vorvan prostý | 0 | +-------------------------------------------------------+------+ 8 rows in set (0.21 sec) mysql> SELECT text, MATCH (text) AGAINST ('vorvaň') AS rel FROM table; +-------------------------------------------------------+------+ | text | rel | +-------------------------------------------------------+------+ | vörvaň prostý | 0 | | lezevec prostý | 0 | | lezevec obecný | 0 | | jezevec obecný | 0 | | jezevec žlutý | 0 | | vorvaň prostý | 0 | | vorvan prostý | 0 | +-------------------------------------------------------+------+ 8 rows in set (0.00 sec) mysql> SELECT text, MATCH (text) AGAINST ('vörvaň') AS rel FROM table; +------------------+---------------------+ | text | rel | +------------------+---------------------+ | vörvaň prostý | 0.28121414780617 | | lezevec prostý | 0 | | lezevec obecný | 0 | | jezevec obecný | 0 | | jezevec žlutý | 0 | | vorvaň prostý | 7.1162265153097e+34 | | vorvan prostý | 0.080910585820675 | +------------------+---------------------+ 7 rows in set (0.00 sec) mysql> INSERT INTO table (text) VALUES ('prosty'); Query OK, 1 row affected (0.11 sec) mysql> SELECT text, MATCH (text) AGAINST ('prosty') AS rel FROM encyklopedie; +------------------+------+ | text | rel | +------------------+------+ | vörvaň prostý | 0 | | lezevec prostý | 0 | | lezevec obecný | 0 | | jezevec obecný | 0 | | jezevec žlutý | 0 | | prosty | 0 | | vorvaň prostý | 0 | | vorvan prostý | 0 | +------------------+------+ 8 rows in set (0.00 sec) mysql> SELECT text, MATCH (text) AGAINST ('Žlutý') AS rel FROM encyklopedie; +------------------+----------------+ | text | rel | +------------------+----------------+ | vörvaň prostý | 0 | | lezevec prostý | 0 | | lezevec obecný | 0 | | jezevec obecný | 0 | | jezevec žlutý | 1.902160525322 | | prosty | 0 | | vorvaň prostý | 0 | | vorvan prostý | 0 | +------------------+----------------+ 8 rows in set (0.00 sec) mysql> SELECT text, MATCH (text) AGAINST ('pröstý') AS rel FROM encyklopedie; +------------------+------+ | text | rel | +------------------+------+ | vörvaň prostý | 0 | | lezevec prostý | 0 | | lezevec obecný | 0 | | jezevec obecný | 0 | | jezevec žlutý | 0 | | prosty | 0 | | vorvaň prostý | 0 | | vorvan prostý | 0 | +------------------+------+ 8 rows in set (0.00 sec)