mysql模糊搜索

SELECT * from userlist WHERE number like '%%' and `name` LIKE '%%'