帝國cms常用的SQL語句有哪些
1.復(fù)制tags字段內(nèi)容到keyboard，當(dāng)keyboard為空的時(shí)候：LaY免費(fèi)資源網(wǎng)

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字段內(nèi)容到keyboard：LaY免費(fèi)資源網(wǎng)

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（相關(guān)鏈接）字段為空，說明keyboard設(shè)置不合理，干脆清空，為自動(dòng)分詞掃清障礙LaY免費(fèi)資源網(wǎng)

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在副表，提取第一張圖片為標(biāo)題圖片。當(dāng)標(biāo)題圖片為空的時(shí)候。LaY免費(fèi)資源網(wǎng)

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;