mysql库查询条件in配合field()函数排序用法

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