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  默默行走  阅读(188)  评论(0)  编辑  收藏  举报