mybatis中的写法
mysql语句的写法
SELECT * FROM `doctor` WHERE id IN(580,579,578,577,576,575,574,573,543,305,321,340,388,402,433) ORDER BY INSTR(',580,579,578,577,576,575,574,573,543,305,321,340,388,402,433,',CONCAT(',',id,','))
本文共 440 字，大约阅读时间需要 1 分钟。
mybatis中的写法
mysql语句的写法
SELECT * FROM `doctor` WHERE id IN(580,579,578,577,576,575,574,573,543,305,321,340,388,402,433) ORDER BY INSTR(',580,579,578,577,576,575,574,573,543,305,321,340,388,402,433,',CONCAT(',',id,','))
转载于:https://www.cnblogs.com/dhrwawa/p/10913460.html