Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- entry,
- MATCH
- (entry)
- AGAINST
- ('>("apple") <(apple*)' IN BOOLEAN MODE)
- AS
- Score
- FROM
- entries
- WHERE
- MATCH
- (entry)
- AGAINST
- ('>("apple") <(apple*)' IN BOOLEAN MODE)
- LIMIT 1
- SELECT
- entry,
- MATCH (entry) AGAINST ('>("apple") <(apple*)' IN BOOLEAN MODE) AS Score
- FROM entries
- WHERE MATCH (entry) AGAINST ('>("apple") <(apple*)' IN BOOLEAN MODE)
- ORDER BY LENGTH(entry)
- LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement