return self::field(true)
->where("is_lunar = 0 and DATE_FORMAT(birthday, '%m-%d') between '{$time['solar_start']}' and '{$time['solar_end']}'")
->whereOr("is_lunar = 1 and DATE_FORMAT(birthday, '%m-%d') between '{$time['lunar_start']}' and '{$time['lunar_end']}'")
->order('id desc')
->paginate();如上查询在5.0下 whereOr 生成的Sql语句是or ，在5.1下生成的是and；这是为何，最终生成的sql见下面。5.0生成的是or 如下：
SELECT `id`,`user_id`,`brand_id`,`card_number`,`member_name`,`tel`,`sex`,`is_lunar`,`birthday`,`job`,`area`,`address`,`score`,`level_id`,`type`,`is_old`,`create_time`,`update_time` FROM `ta_vip_member` WHERE ( is_lunar = 0 and DATE_FORMAT(birthday, '%m-%d') between '03-22' and '03-22' ) OR ( is_lunar = 1 and DATE_FORMAT(birthday, '%m-%d') between '02-16' and '02-16' ) ORDER BY `id` DESC5.1.35生成的如下，唯一不同就是or变成了and
SELECT `id`,`user_id`,`brand_id`,`card_number`,`member_name`,`tel`,`sex`,`is_lunar`,`birthday`,`job`,`area`,`address`,`score`,`level_id`,`type`,`is_old`,`create_time`,`update_time` FROM `ta_vip_member` WHERE ( is_lunar = 0 and DATE_FORMAT(birthday, '%m-%d') between '03-22' and '03-22' ) AND ( is_lunar = 1 and DATE_FORMAT(birthday, '%m-%d') between '02-16' and '02-16' ) ORDER BY `id` DESC 最佳答案
