mysql自定义排序

格式为:
order by field(value,str1,str2,str3,str4,strn)

示例:
select * from user by field(name,‘zhangsan’,‘lisi’,‘wangwu’);

posted @ 2020-03-06 10:35  790021521  阅读(136)  评论(0编辑  收藏  举报