select device_id,age,university
from user_profile
where university like '%北京%'

# _匹配任意一个字符
#%匹配零个或多个字符