Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @str = 'Felix';
- SELECT * FROM (
- SELECT body, 1 AS table_order FROM articles AS a1 WHERE SOUNDEX(a1.body) = SOUNDEX(@str)
- UNION ALL
- SELECT body, 2 AS table_order FROM articles AS a2 WHERE levenshtein(body, @str) BETWEEN 0 AND 5 ORDER BY levenshtein(body, @str)
- ) AS articles ORDER BY table_order ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement