- in查询,默认会将查询的条件按数字正序排序,那我们不需要排序怎么办?
$exp = new thinkdbExpression(‘field(id,’.implode(‘,’,$province_ids).’)’);
$list = Db::name(‘表名’)->where([‘id’=>[‘in’,$province_ids],’status’=>1])->field(‘id,name’)->order($exp)->select();
- 闭包查询,子查询
$list = Db::name(‘dict_region’)->where(‘id’,’IN’,function($query) use($where){
$query->table(‘这里的表名要带前缀’)->where($where)->field(‘province’);
})->field(‘id,name’)->select();
- order排序里面使用函数
$arr = Db::name(‘表名’)
->alias(‘a’)
->join(‘product_goods b’,’a.goods_id=b.id’)
->where($where)
->group(“a.goods_id”)
->orderRaw(“sum(a.publish_num) desc”) //将a表的publish_num的和作为排序的标准
->field(“goods_id as id,b.name,sum(a.publish_num) as num”)
->select();
- wherOr的查询
$list = Db::name(‘message’)
->alias(‘a’)
->join(‘user b’,’a.user_id=b.id’)
->where($where)
->where(function ($query) use ($keywords) {
$query->whereOr([‘username’=>[‘like’,’%’.$keywords.’%’]]) //昵称模糊搜索
->whereOr([‘nickname’=>[‘like’,’%’.$keywords.’%’]]); //昵称模糊搜索
})
->order(‘a.id desc’)
->select();
文章来源于互联网:tp5 有点技巧性的sql语句
I’m extremely impressed together with your writing abilities as neatly as with the format to your blog. Is this a paid theme or did you customize it your self? Either way keep up the nice high quality writing, it?s uncommon to look a nice blog like this one nowadays..
Esenyurt Esenyurt istanbul hurdacı firmasıyız. Esenyurt hurda fiyatları ile yerinden hurda alıyoruz. Nakit ödemeyle hurda alıyoruz. Hurdacı numarası https://www.hurdacisitesi.com.tr
There are some fascinating cut-off dates on this article however I don?t know if I see all of them middle to heart. There is some validity however I’ll take maintain opinion until I look into it further. Good article , thanks and we want more! Added to FeedBurner as properly
Esenyurt Esenyurt istanbul hurdacı firmasıyız. Esenyurt hurda fiyatları ile yerinden hurda alıyoruz. Nakit ödemeyle hurda alıyoruz. Hurdacı numarası https://www.hurdacifirma.com.tr
Hurda bakır alan Esenyurt hurdacı firması olarak her türlü madeni değerinde alıyoruz. Hurda alım satımında lider konumdayız..
canadian medications
buy medicine canada
over the counter drug store