By visiting http://yourblog.com/wp-admin/options.php (Where yourblog.com is your blog’s url), you can access additional settings and options for fine-tuning your blog. It’s literally called the ‘All Settings’ page, which is a great place to change default settings you normally would have to hack around or download a plugin for.
Replacing, Updating, Changing text in WordPress fields is as easy as using the MySQL replace command. Here’s an example for updating the post_title field: update wp_posts set post_title = REPLACE(post_title, ‘Old’, ‘New’) WHERE post_title LIKE ‘%Old%’; This will update all the columns that have the word ‘Old’ in their post_title field with the word ‘New’.… Continue reading In WordPress, Replace Text In All Fields
A great list to know: WordPress, Reserved Terms A lot of issues can arrise if reserved terms are used in customization of WordPress Taxonomy and Post Types. Just best to avoid these terms in whole.
SQL code to change all pending comments to spam: UPDATE `wp_comments` SET `comment_approved`=’spam’ WHERE `comment_approved` = 0; If you’re not using Akismet, and you’ve let your pending, most likely “spam” comments, pile-up; the above SQL code will help convert all pending comments to spam. So comments like: What an insightful idea has been written here.… Continue reading Spam all pending WordPress comments SQL statment