Tag Archive: sql statement

June 10, 2012 / by Marco / database, mysql database, phpadmin, plugin, pluging, SQL, sql statement, statement, type, type comments, way, website, WHERE, Wordpress

How do you delete all the pending comments in WordPress

I fyou get annoyed at all the spammed comments in your WordPress and want to delete all these in one go then there are two options available to delete all the pending comments in your WordPress website. One way is to go into the mysql database via phpadmin and use an SQL statement and delete […]

How to update pricings for all products in jigoshop

REMEMBER to backup your database before making any changes!!! In order to change the prices for all products in your store, you will need to get into your database (mysql) and run an SQL statement. Here’s an example to change the prices for ALL PRODUCTS to 90% of the original price: update wp_postmeta set meta_value […]