thinkphp查询表达式
数据模糊查询
//查询nihao表中name字段带有小字的数据
Db::table('nihao')->where('name','like','小%')->select();
like查询支持使用数组进行多个模糊查询
//查询nihao表中name字段带有小字的和带有七字的数据
Db::table('nihao')->where('name','like',['小%','%七%'],'or')->select();
区间查询
//查询nihao表中id为1-8的数据
Db::name('nihao')->where('Id','between','1,8')->select();
Db::name('nihao')->where('Id','between',[1,8])->select();
IN查询
//查询nihao表中id为1,5,8的数据
Db::name('nihao')->where('id','in','1,5,8')->select();
Db::name('nihao')->where('id','in',[1,5,8])->select();