题解 | #查看学校名称中含北京的用户#
查看学校名称中含北京的用户
https://www.nowcoder.com/practice/95d9922b1e2a49de80daa491889969ee
select device_id,age,universityfrom user_profile where university like '%北京%';select device_id,age,universityfrom user_profile where university regexp '北京';
select device_id,age,universityfrom user_profile where university rlike '北京';
select device_id,age,universityfrom user_profile where locate('北京',university);
select device_id,age,universityfrom user_profile where instr(university,'北京');
select device_id,age,universityfrom user_profile
where substr(university,1,2) = '北京';
