Advertisement
Guest User

Untitled

a guest
Apr 1st, 2015
226
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. mysql> insert into searchable_content () VALUES ();
  2. Query OK, 1 row affected (0.00 sec)
  3.  
  4. mysql> insert into searchable_content () VALUES ();
  5. Query OK, 1 row affected (0.00 sec)
  6.  
  7. mysql> SELECT
  8. page_id,
  9. MATCH(`content`) AGAINST ('blabbity') AS 'relevance'
  10. FROM
  11. `searchable_content` WHERE
  12. MATCH(`content`) AGAINST ('blabbity');
  13. +---------+--------------------+
  14. | page_id | relevance |
  15. +---------+--------------------+
  16. | 42 | 0.3573872447013855 |
  17. +---------+--------------------+
  18. 1 row in set (0.00 sec)
  19.  
  20. mysql> SELECT
  21. page_id,
  22. MATCH(`content`) AGAINST ('+blabbity' IN BOOLEAN MODE) AS 'relevance'
  23. FROM
  24. `searchable_content`
  25. WHERE MATCH(`content`) AGAINST ('+blabbity' IN BOOLEAN MODE);
  26. +---------+-----------+
  27. | page_id | relevance |
  28. +---------+-----------+
  29. | 42 | 1 |
  30. +---------+-----------+
  31. 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement