mysql 数据加密

1.表结构

CREATE TABLE `jiami` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` blob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

2.加密

insert into jiami (name) values (encode("luffy","knife"));

3.解密

select decode(name,"knife") from jiami;

4.按条件查找

select decode(name,"knife") from jiami where decode(name,"knife") = "luffy";

5.编码

select CAST(BINARY(DECODE(name,"knife")) AS CHAR CHARACTER SET utf8) AS "utf8name" from jiami