1、未排序之前查询结果：
select * from tt_model_replace_subsidy;
image.png
2、指定field()排序规则查询结果：
select * from tt_model_replace_subsidy where model_code in ('C423FZ','C423','C42') order by field(model_code,'C423FZ','C423','C42');
image.png
1、未排序之前查询结果：
select * from tt_model_replace_subsidy;
2、指定field()排序规则查询结果：
select * from tt_model_replace_subsidy where model_code in ('C423FZ','C423','C42') order by field(model_code,'C423FZ','C423','C42');
本文标题：mysql库查询条件in配合field()函数排序用法
本文链接：https://www.haomeiwen.com/subject/fxfggltx.html
网友评论