mysql 특정 단어를 정렬(order by)에 반영하기

CASE ca_name WHEN '공지1' THEN 1 WHEN '공지2' THEN 2 WHEN '공지3' THEN 3 ELSE 4 END, cl_order asc

 

order by FIELD(ca_name, '공지1', '공지2') desc, wr_20 is null asc, wr_20 desc, wr_datetime desc