Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID Language Text
- 0 ENU a
- 0 JPN b
- 0 DAN c
- 1 ENU d
- 1 JPN e
- 1 DAN f
- 2 etc...
- ORDER BY `ID`,
- CASE `Language`
- WHEN 'ENU' THEN 1
- WHEN 'JPN' THEN 2
- WHEN 'DAN' THEN 3
- END
- ORDER BY `ID`,
- CASE `Language`
- WHEN 'ENU' THEN 1
- WHEN 'JPN' THEN 2
- WHEN 'DAN' THEN 3
- ELSE 4
- END,
- `Language`
- )
- SELECT * FROM table
- ORDER BY CASE Language
- WHEN 'ENU' THEN 3
- WHEN 'JPN' THEN 2
- WHEN 'DAN' THEN 1
- ELSE 0
- END DESC, ID ASC
Add Comment
Please, Sign In to add comment