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

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=\’\’;

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<>\’\’;

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=\’\’

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;

文章轉自：黎青松SEO博客

來源地址：http://www.alitaohuo.com/CMSjiaocheng/diguojiaocheng/1685.html

更多關于云服務器，域名注冊，虛擬主機的問題，請訪問西部數碼官網：www.west.cn