1.使用in查询如何保证顺序
普通查询:order(field(id,3,4,2,1,6,13))
tp5:
引入use think\db\Expression;
$ids = '3,2,1,6,33,11';
$exp = new Expression('field(id,'.$ids.')'); //用于排序
$list = db('article',[],false)->order($exp)->select();
1.使用in查询如何保证顺序
普通查询:order(field(id,3,4,2,1,6,13))
tp5:
引入use think\db\Expression;
$ids = '3,2,1,6,33,11';
$exp = new Expression('field(id,'.$ids.')'); //用于排序
$list = db('article',[],false)->order($exp)->select();