[MYSQL]OrderByCase操作

• e1

SELECT * FROM currency_codes
  ORDER BY
  CASE
    WHEN code='USD' THEN 1
    WHEN code='CAD' THEN 2
    WHEN code='AUD' THEN 3
    WHEN code='BBD' THEN 4
    WHEN code='EUR' THEN 5
    WHEN code='GBP' THEN 6
    ELSE 7
  END,name;

• e2

SELECT id,url,sid,type,episode 
FROM webview_play_info 
WHERE tag0 IN (0,1) 
AND tag1 IN (2) 
AND type='ccc' 
AND is_delete=0 
ORDER BY 
CASE 
WHEN url LIKE '%aaa%' THEN 1 
WHEN url LIKE '%bbb%' THEN 2 
ELSE 3
END,
episode DESC,
insert_time DESC 
LIMIT 10;