sql根据查询顺序返回结果

SELECT id,autonum FROM program WHERE autonum IN (202000016,202001072) order by FIELD(autonum,202000016,202001072);

posted @ 2020-10-21 20:18  Tudoo  阅读(606)  评论(0编辑  收藏  举报