题解 | #筛选出学校名中包含特定关键词的用户#
筛选出学校名中包含特定关键词的用户
https://www.nowcoder.com/practice/db591191caf2437592abebdbe437ae2b
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 '%成人%' )