Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- innodb_ft_min_token_size = 1
- innodb_ft_enable_stopword = off
- ft_min_word_len = 1
- SELECT * FROM animals
- WHERE MATCH (story)
- AGAINST ('+lazy +dog' IN BOOLEAN MODE);
- +----+--------+--------------------------------------------------+
- | id | animal | story |
- +----+--------+--------------------------------------------------+
- | 1 | dog | Brown fox jumped over lazy dog |
- | 4 | dog | Grey flea jumped on lazy dog |
- | 3 | dog | Black ox jumped near lazy dog in the land of OZ. |
- | 2 | dog | White fox jumped on lazy dog |
- +----+--------+--------------------------------------------------+
- SELECT * FROM animals
- WHERE MATCH (story)
- AGAINST ('+on +lazy +dog' IN BOOLEAN MODE);
- Empty set (0.00 sec)
- SELECT * FROM animals
- WHERE MATCH (story)
- AGAINST ('+dog +OZ' IN BOOLEAN MODE);
- Empty set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement