SHOW:
|
|
- or go back to the newest paste.
| 1 | SELECT *, | |
| 2 | (name IN ('František', 'Áron', 'Kopecký')) AS nameFound,
| |
| 3 | (surname IN ('František', 'Áron', 'Kopecký')) AS surnameFound
| |
| 4 | FROM people | |
| 5 | - | ORDER BY (nameFound = 1 AND surnameFound = 1) DESC |
| 5 | + | ORDER BY (nameFound = 1 AND surnameFound = 1) DESC, surnameFound DESC |
| 6 | GROUP BY id | |
| 7 | HAVING nameFound = 1 OR surnameFound = 1 |
