实例:
SELECT plate_no,user_car_id FROM customer_user_car WHERE user_car_id IN (57603,57612,57607,57605)
这样的情况取出来后,其实,id还是按由小到大排序的,但如果我们真要按IN里面的顺序排序怎么办?SQL能不能完成?是否需要取回来后再foreach一下?其实mysql就有这个方法 :
SELECT plate_no FROM customer_user_car WHERE user_car_id IN (57603,57612,57607,57605) ORDER BY FIELD(user_car_id,57603,57612,57607,57605)
另一个使用group_concat时的例子:
SELECT GROUP_CONCAT(COUNT ORDER BY FIELD(template_member_id,20,19,18)) AS counts FROM market_item_counting_card_template_memeber WHERE template_member_id IN (20,19,18)
记录一下。
参考自:
https://blog.csdn.net/swazer_z/article/details/50633964