题目如下:
解题一:like模糊查询
select id,device_id,university
from user_profile
where (university like '北京%' or university like '上海%')
and (university like '%学院' or university like '%校区')
and (university like '%职业%' or university like '%专科%' or university like '%成人%')
解题二:正则表达式搭配regexp
select id, device_id, university
from user_profile
where university regexp '^(北京|上海).*(职业|专科|成人).*(学院|校区)$'