Shulou(Shulou.com)06/03 Report--

The editor will share with you how PhpCms V9 modifies keywords in batches. I hope you will get something after reading this article. Let's discuss it together.

The overall experience of PHPCSM content management system is not very good! But it was found that since it was bought by the authorities. Found that the official pace is unable to keep up with the needs of users. In the old version of PHPcms2008, it is about the function of batch replacement of keywords. However, there is no small function to add batch replacement keywords to the new version of PHPcms V9. Shinichi also records his SQL statements of replacing keywords in batches in his blog for those who need them.

/ * Article title * /

Update v9_news set title=replace (key to title,' error', 'replace with new one')

/ * Article description * /

Update v9_news set description=replace (key to description,' error', 'replace with new one')

/ * keywords of the article * /

Update v9_news set keywords=replace (key to keywords,' error', 'replace with new one')

/ * content of the article * /

Update v9_news_data set content=replace (key to content,' error', 'replace with new one')

Simple and powerful SQL statement. Thank you for your strong advice on learning.

After reading this article, I believe you have a certain understanding of "how to modify keywords in batch in PhpCms V9". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.