mysql去重后显示BLOB格式

用 select  cast(content as char) from table可以解决

 select DISTINCT CAST(phone as char)  from (SELECT  AES_DECRYPT(from_base64(mobile ), 'YYUANSecretKey*&') phone
  FROM ims_industry_members where mobile is NOT  NULL and mobile!=""  ) as member where phone LIKE "%*%"