SELECT *
FROM `crm_class`
WHERE class_id
IN ( 1, 2, 3, 4 )
ORDER BY FIELD( class_id, 2, 3, 4, 1 )
LIMIT 0 , 30
SELECT *
FROM `crm_class`
WHERE class_id
IN ( 1, 2, 3, 4 )
ORDER BY FIELD( class_id, 2, 3, 4, 1 )
LIMIT 0 , 30
转载于:https://www.cnblogs.com/whoamme/archive/2012/06/06/2537831.html