The PHPCSM content management system has a good experience in all aspects! However, it was discovered that it had been officially acquired by Shanda. It is found that the official pace is not keeping up with the user's needs. In earlier versions of PHPcms2008, keyword batch replacement is available. However, the new version of PHPcms V9 is not provided with a small function to replace keywords in batches. The new version also records SQL statements that replace keywords in batches in a new blog for users.
The code is as follows: |
Copy code |
/* Article title */ Update v9_news set title = replace (title, 'Key of The error', 'replace with new '); /* Article description */ Update v9_news set description = replace (description, 'Key of The error', 'replace with new '); /* Keyword */ Update v9_news set keywords = replace (keywords, 'Key of The error', 'replace with new '); /* Article content */ Update v9_news_data set content = replace (content, 'Key of The error', 'replace with new '); |
Simple and powerful SQL statements. Thank you for your strong suggestions.