限时免费试用:欢迎注册 api.bigmodel.org ,快速体验大模型 API 接入服务。
当前位置:首页 >数据库 >Mysql

数据库查询中的between用法

分类:Mysql时间:2018-06-26浏览:3523
$list = $this->model->table('post')->field('title,pic,id,author, time,is_ok')->where($condition)
->where('author="'.$uname.'"'.' and  time between '.$time_l .' and '.$time_r  )->limit($limit)
->order('time desc,id desc')->select();
and k1 between $start and $end
本站文章如未注明出处均为原创,转载请注明出处,如有侵权请邮件联系站长。
0/500
Share your thoughts respectfully.