1.復制tags字段內容到keyboard，當keyboard為空的時候：

copyright limeiseo

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.keyboard=a.infotags where a.id=b.id and b.keyboard=''; copyright limeiseo

2.添加tags字段內容到keyboard：

利美項目圈

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.keyboard=concat(b.keyboard,',',a.infotags) where a.id=b.id and b.keyboard'' and a.infotags'';

copyright limeiseo

3.如果副表中keyid（相關鏈接）字段為空，說明keyboard設置不合理，干脆清空，為自動分詞掃清障礙

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.keyboard='' where a.id=b.id and a.keyid=''

本文利美網絡（m.jiyipeiwo.com）整理發布

4.newstext在副表，提取第一張圖片為標題圖片。當標題圖片為空的時候。

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, '.jpg', 1),'src=',-1),'"',''),'.jpg') where a.newstext like '%.jpg%' and b.titlepic='' and a.id=b.id; 利美知識百科

update [!db.pre!]ecms_news_data_1 a, [!db.pre!]ecms_news b set b.titlepic=concat(replace(SUBSTRING_INDEX(SUBSTRING_INDEX(a.newstext, '.gif', 1),'src=',-1),'"',''),'.gif') where a.newstext like '%.gif%' and b.titlepic='' and a.id=b.id; limeiseo（加v分享）

本文標簽：