$data = Db::name('list')
->where('status',$status)
->where('DATE_FORMAT(datetime, "%Y-%m")','2017-06')
->select();执行打印出来的sql:SELECT * FROM `tb_list` WHERE `status` = 1 AND (DATE_FORMAT(datetime, "%Y-%m") )缺少 = '2017-06' 这段值正确的SQL应该是
SELECT * FROM tb_list WHERE status = 1 AND DATE_FORMAT(datetime, '%Y-%m')='2017-06' 最佳答案