Access additional hidden options in WordPress

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.

In WordPress, Replace Text In All Fields

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

Spam all pending WordPress comments SQL statment

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