SQL查询语句如下:
select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) 让结果按10,32,22,76,13,44的顺序检索出来,请问如何书写? (sql能力)
select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) 让结果按10,32,22,76,13,44的顺序检索出来,请问如何书写? (sql能力)
select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) order by FIND_IN_SET(id,"10,32,22,76,13,44")
去mysql版问 能得到更好的结果
SELECT * FROM `table` WHERE ID IN (10,32,22,76,13,44) ORDER BY FIND_IN_SET(ID,'10,32,22,76,13,44')