修改属性
update yt_portal_post a,aaa_copy b set a.y2=b.log_Meta where a.id=b.log_ID and b.log_Meta !=''
转移文章
INSERT INTO yt_portal_post (id, post_alias, post_title,post_excerpt,post_content,create_time,update_time,published_time) SELECT log_ID, log_Alias,log_Title,log_Intro,log_Content,log_PostTime,log_PostTime,log_PostTime FROM zbp_post;
删除mysql前面指定字符
update aaa_copy set log_Meta = '' where log_CateID != 2; update aaa_copy set log_Meta = substring_index( log_Meta, ':"', -1 );
删除mysql后面指定字符
update aaa_copy set log_Meta = LEFT(log_Meta, INSTR(log_Meta, '";') -1);
删掉多余字符
update aaa_copy set log_Meta=REPLACE (log_Meta,'a:','')