_:匹配任意一个字符

%:匹配0个或多个字符

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