MYSQL可以查询出来。各位大神请教PHP怎么写
SELECT uid,real_name,AES_DECRYPT(from_base64(u.real_name),'123456') from eb_user where AES_DECRYPT(from_base64(real_name),'123456') LIKE '%张%';
后端改写查不出来数据:
$query->where("AES_DECRYPT(from_base64(real_name),'123456')", "like", "%" . $value . "%");