mysql in 按照in里面的数字排序,SQL语句
SELECT * from article WHERE id in (10,30,20) ORDER BY FIELD(id,10,30,20)
注意:这里id没有单引号,如果写成FIELD('id',10,30,20))是不生效的哦
SELECT * from article WHERE id in (10,30,20) ORDER BY FIELD(id,10,30,20)
注意:这里id没有单引号,如果写成FIELD('id',10,30,20))是不生效的哦