Mysql数据库加密实现模糊查询

# 重启失效，解决创建函数报错：This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
set global log_bin_trust_function_creators = TRUE;
# 封装加密函数
create function ext_encrypt(data varchar(11)) returns varchar(32)
begin
    return HEX(AES_ENCRYPT(data, 'FIVwpBSUcXZJxs5l'));
end;

# 封装解密函数
create function ext_decrypt(data varchar(32)) returns varchar(11)
begin
    return AES_DECRYPT(UNHEX(data), 'FIVwpBSUcXZJxs5l');
end;

# 密钥为：FIVwpBSUcXZJxs5l
# 加密结果为：1D49A221B869DE5D22F67C69D8DE05ED
select ext_encrypt('19999999999');
insert into table_name (phone) value (ext_encrypt('19999999999'));
# 模糊查询
select *,ext_decrypt(phone) real_phone from table_name where ext_decrypt(phone) like '199%';