背景需求:查出的数据需要按照传入条件的顺序展示: select * from t where s in ('aaa','ddd','ccc','eee') 。
如果想按照s传入的顺序排序,需要增加 order by field():
select * from t where s in ('aaa','ddd','ccc','eee') order by field(s,'aaa','ddd','ccc','eee') 。
thinkPHP 5支持以下写法:
$value = ['aaa','ddd','ccc','eee'];
$t = new T();
$val = imploed(',', $value);
$list = $t->where('s', IN, $val)->order('field(s,'.$val.')')->select();
注意点:
1、$value要转换成字符串$val ;
2、如果s字段是字符串类型,mysql会将排序的值(aaa,ddd....)当做数据库的字段,此时会报错找不到该字段(aaa...),如下图
此时,$value转字符串时,要给每个值加引号,即 $val = ‘"’ . imploed(‘","’, $value) . ‘"’;