Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. innodb_ft_min_token_size = 1
  2. innodb_ft_enable_stopword = off
  3. ft_min_word_len = 1
  4.  
  5. SELECT * FROM animals
  6. WHERE MATCH (story)
  7. AGAINST ('+lazy +dog' IN BOOLEAN MODE);
  8.  
  9. +----+--------+--------------------------------------------------+
  10. | id | animal | story |
  11. +----+--------+--------------------------------------------------+
  12. | 1 | dog | Brown fox jumped over lazy dog |
  13. | 4 | dog | Grey flea jumped on lazy dog |
  14. | 3 | dog | Black ox jumped near lazy dog in the land of OZ. |
  15. | 2 | dog | White fox jumped on lazy dog |
  16. +----+--------+--------------------------------------------------+
  17.  
  18. SELECT * FROM animals
  19. WHERE MATCH (story)
  20. AGAINST ('+on +lazy +dog' IN BOOLEAN MODE);
  21.  
  22. Empty set (0.00 sec)
  23.  
  24. SELECT * FROM animals
  25. WHERE MATCH (story)
  26. AGAINST ('+dog +OZ' IN BOOLEAN MODE);
  27.  
  28. Empty set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement