select id,device_id,university
from user_profile
where university rlike '^(北京|上海).*(职业|专科|成人).*(学院|校区)$';