Mysql中IN与Order BY一起用的特殊性

select * from voucher where voucher_id in (5,3,1);

 

 select * from voucher where voucher_id in (5,3,1) order by field(voucher_id,5,3,1);

 

posted @ 2022-05-20 16:46  lenlewan  阅读(178)  评论(0)    收藏  举报