Mysql查询--查询结构按照In的顺序排列

SELECT * FROM ********* info WHERE projectid in (99999999,35566789,23456726,12345678) ORDER BY FIELD(projectid,99999999,35566789,23456726,12345678)

 

posted @ 2018-07-16 15:41  默默行走  阅读(192)  评论(0)    收藏  举报