Select Page

How to delete all images from your WordPress site

Use this SQL to remove all images/documents/etc from your media library 1 – Run these in phpmyadmin DELETE FROM wp_postmeta WHERE post_id IN ( SELECT id FROM wp_posts WHERE post_type = 'attachment' ) ; DELETE FROM wp_posts WHERE post_type = 'attachment' 2...

Change all PrestaShop products to show price

Using this command you can easily set all products to show the price. UPDATE `ps_product` SET show_price =1 WHERE show_price =0 UPDATE `ps_product_shop` SET show_price =1 WHERE show_price =0

Move WordPress site to another domain name

Use these SQL commands if you are moving your website from one domain to another. Change Siteurl and Homeurl UPDATE wp_options SET option_value = replace(option_value, 'http://www.nick-shaw.com', 'https://www.nick-shaw.co.uk') WHERE option_name = 'home' OR option_name...