应用场景:当排序既不是升序,也不是降序,必须按照指定的顺序时,
SELECT * FROM test WHERE id IN (5,3,6,1)
(1) ORDER BY FIELD(id,5,3,6,1);
(2) ORDER BY find_in_set(a.id,'5,3,6,1');
应用场景:当排序既不是升序,也不是降序,必须按照指定的顺序时,
SELECT * FROM test WHERE id IN (5,3,6,1)
(1) ORDER BY FIELD(id,5,3,6,1);
(2) ORDER BY find_in_set(a.id,'5,3,6,1');