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

用 university like "%北京%"

哈哈