thinkphp5查询表达式IN使用小计

根据多个id批量更新指定字段值

$map[] = ['id','in', input('post.id/a')]; 

$result = db('picture')->where($map)->update(['posid' => 1]);

相当于sql语句： 

UPDATE `yj_picture`  SET `posid` = 1  WHERE  `id` IN (1,2,3)

 

使用表达式like进行模糊查询

$map[] = array('title','like','%'.$keywords.'%');

db('picture')->where($map)->find();

持续更新.......

转载于:https://www.cnblogs.com/wenbino/p/10419843.html