SQL Archives - Freelance Web Developer Manchester | SEO Consultant

SQL query to export all WooCommerce products

If you want to get all the WooCommerce products ready to be saved into a CSV / Excel file run the following query:   SELECT ID, post_status, post_title, post_content, post_excerpt, guid FROM `wp_posts` WHERE (`post_status` = 'publish' OR `post_status` = 'draft') AND...

Find and replace text – SQL

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring"); 1 UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");  ...