PHPCSM Content Management System overall experience in all aspects of whether it is very good! But the discovery has since been officially given a grand takeover. Find the official pace is not keeping up with the needs of users. In the old version of PHPcms2008, there is a feature of keyword bulk substitution. But did not give the new Phpcms V9 plus batch replacement keyword small function. The new one also put their own every time the batch of SQL statements to replace keywords in the blog to the needs of people to use.
/* Article title */
Update v9_news set Title=replace (title, ' Wrong key ', ' Replace with new one ');
/* Article Description */
Update v9_news Set Description=replace (description, ' wrong key ', ' Replace with new one ');
/* Article keywords */
Update v9_news set Keywords=replace (keywords, ' wrong key ', ' Replace with new one ');
/* Article content */
Update V9_news_data set Content=replace (content, ' Error key ', ' Replace with new one ');
Simple and powerful SQL statement. Thanks to the students strongly recommend learning AH.
Phpcms V9 Bulk Edit Keywords