mysql 查询主键排序有关问题

mysql 查询主键排序问题

id是主键,查询就会默认的按主键排序,可不可以去掉这个排序,就按照我的 4 3 1 排序出来

select * from article where id = 4 or id = 3 or id = 1



select * from article order by find_in_set(id,’4,3,1′)

or

select * from article order by if(id = 4,1,if(id = 3,2,if(id = 1,3,4)))




select * 

from article 

where id = 4 or id = 3 or id = 1

order by find_in_set(id,’4,3,1′)

mysql 查询主键排序有关问题

相关文章:

你感兴趣的文章:

标签云: