Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *,
- (name IN ('František', 'Áron', 'Kopecký')) AS nameFound,
- (surname IN ('František', 'Áron', 'Kopecký')) AS surnameFound
- FROM people
- ORDER BY (nameFound = 1 AND surnameFound = 1) DESC
- GROUP BY id
- HAVING nameFound = 1 OR surnameFound = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement