urlencode转义字符mysql模糊搜索

微信昵称带表情的昵称  用php自带urlencode转义后存入数据库

听雨轩 存入为  %E6%A1%89%E6%A0%91%F0%9F%8C%B2          

mysql 模糊搜索需要转义才能匹配到

$name = '听雨轩';
$name = str_replace("%", "\%", urlencode($name));
select * from tableA where name like '%'.$name.'%';