#SELECT * FROM `cqbmh_com`.`pwn_base_plus` WHERE CAST(`cqbmh_com`.`pwn_base_plus`.`coltype` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`pluslable` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`plusname` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`plustype` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`pluslocat` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`tempname` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`tempcolor` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`showborder` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`bordercolor` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`borderstyle` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`borderlable` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`borderroll` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`showbar` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`barbg` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`barcolor` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`backgroundcolor` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`morelink` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`ord` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`sc` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`target` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`fittype` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`title` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`body` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`pic` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`piclink` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`attach` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`movi` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`sourceurl` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`word` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`word1` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`word2` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`word3` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`word4` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`text` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`text1` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`code` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`link` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`link1` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`link2` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`link3` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`link4` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`tags` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`groupid` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`projid` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`overflow` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`bodyzone` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%' OR CAST(`cqbmh_com`.`pwn_base_plus`.`display` AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci LIKE '%langfang520%'

UPDATE `cqbmh_com`.`pwn_base_plus` SET body = "" WHERE body like '%langfang520%';

select * from cqbmh_com.pwn_base_plus where body like '%langfang520%';
select * from cqbmh_com.pwn_base_plus where 1;