1、REGEXP
SELECT device_id, age, university FROM user_profile WHERE university REGEXP "北京"
2、LIKE
SELECT device_id, age, university FROM user_profile WHERE university LIKE "%北京%"
SELECT device_id, age, university FROM user_profile WHERE university REGEXP "北京"
SELECT device_id, age, university FROM user_profile WHERE university LIKE "%北京%"
牛客博客，记录你的成长
京公网安备 11010502036488号