根据地区、身份证、是否通过为条件 创建时间近两年数据
SELECT * FROM `user` WHERE area_code LIKE CONCAT('3310','%') AND identity_card = '身份证' AND wipe_out_state = 0 AND DATE_SUB(CURDATE(),INTERVAL 2 YEAR) <= into_date
根据地区、身份证、是否通过为条件 创建时间近两年数据
SELECT * FROM `user` WHERE area_code LIKE CONCAT('3310','%') AND identity_card = '身份证' AND wipe_out_state = 0 AND DATE_SUB(CURDATE(),INTERVAL 2 YEAR) <= into_date