Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT
  2. entry,
  3. MATCH
  4. (entry)
  5. AGAINST
  6. ('>("apple") <(apple*)' IN BOOLEAN MODE)
  7. AS
  8. Score
  9. FROM
  10. entries
  11. WHERE
  12. MATCH
  13. (entry)
  14. AGAINST
  15. ('>("apple") <(apple*)' IN BOOLEAN MODE)
  16. LIMIT 1
  17.  
  18. SELECT
  19. entry,
  20. MATCH (entry) AGAINST ('>("apple") <(apple*)' IN BOOLEAN MODE) AS Score
  21. FROM entries
  22. WHERE MATCH (entry) AGAINST ('>("apple") <(apple*)' IN BOOLEAN MODE)
  23. ORDER BY LENGTH(entry)
  24. LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement