UPDATE dr_1_news SET title = replace(title,'??','?');

UPDATE dr_1_news SET title = replace(title,'&','&');

UPDATE dr_1_news SET title = replace(title,'<','"');

UPDATE dr_1_news SET title = replace(title,'>','&');

UPDATE dr_1_news SET title = replace(title,'"','"');

UPDATE dr_1_news SET title = replace(title,'(组图)','');

UPDATE dr_1_news SET title = replace(title,'(图)','');

# mysql 替换内容 , 去掉分页标识符

UPDATE dr_1_news_data_0 SET content = replace(content,'','')

# 迁移网站-替换新域名, 内容编辑器中含有老地址

update dr_1_page set `content`=replace(`content`,'原来的域名', '现在的域名');
update dr_1_share_category set `content`=replace(`content`,'原来的域名', '现在的域名');
update dr_1_block set `content`=replace(`content`,'原来的域名', '现在的域名');
update dr_1_模块目录_data_0 set `content`=replace(`content`,'原来的域名', '现在的域名');

# 删除少于字符数100的记录

SELECT * FROM `dr_1_news_data_0` WHERE LENGTH(content) <= '100';

SELECT * FROM `dr_1_news_data_1` WHERE LENGTH(content) <= '100';

SELECT * FROM `dr_1_news_data_2` WHERE LENGTH(content) <= '100';

SELECT * FROM `dr_1_news` WHERE LENGTH(keywords) <= '20' 

delete from `dr_1_news_data_2` where id in (111233,111237,111248,111250,111277,111473,111747,111751,111887,112199,112252,112278,112282,112309,112314,112333,112352,112386,112387,112423,112447,112457,112510,112625,112637,112639,112700,112707,112708,112709,112712,112724,112736,112764,112766,112787,112830,112842,112878,112974,112989,112999,113014,113037,113051,113069,113072,113121,113168,113258,113428,114018,116212,116710,116725,117939,118855,123716);

delete from `dr_1_news` where id in (111233,111237,111248,111250,111277,111473,111747,111751,111887,112199,112252,112278,112282,112309,112314,112333,112352,112386,112387,112423,112447,112457,112510,112625,112637,112639,112700,112707,112708,112709,112712,112724,112736,112764,112766,112787,112830,112842,112878,112974,112989,112999,113014,113037,113051,113069,113072,113121,113168,113258,113428,114018,116212,116710,116725,117939,118855,123716);