比如需要这样的效果:
SELECT project_name,pre_sale_number from estate_project_info WHERE loc_area='海淀区' AND (pre_sale_number like '%2016%' or pre_sale_number like '%2017%')
可以使用 REGEXP 写成:
SELECT project_name,pre_sale_number from estate_project_info WHERE loc_area='海淀区' AND pre_sale_number REGEXP '2016|2017|2018|2019|2020'