INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES ({POST_ID},'_yoast_wpseo_meta-robots-noindex',1);Showing 1 lines of 2 total lines in this snippet.
showCategory('MySQL');
Change WP Database Prefix
UPDATE `newprefix_options` SET `option_name`=REPLACE(`option_name`,'wp_','newprefix_') WHERE `option_name` LIKE '%wp_%'; UPDATE `newprefix_usermeta` SET `meta_key`=REPLACE(`meta_key`,'wp_','newprefix_') WHERE `meta_key` LIKE '%wp_%';
Showing 2 lines of 7 total lines in this snippet.
SQL replace text in column
UPDATE table SET column = replace(column, 'text', 'replacement');
Showing 1 lines of 3 total lines in this snippet.
SQL select unique (distinct) values
SELECT DISTINCT column FROM table;
Showing 1 lines of 1 total lines in this snippet.
SQL queries to move WordPress
UPDATE wp_options SET option_value = replace(option_value, 'http://www.sitename.com', 'https://www.sitename.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'http://www.sitename.com','https://www.sitename.com'); UPDATE wp_posts SET post_content = replace(post_content, 'http://www.sitename.com', 'https://www.sitename.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.sitename.com','https://www.sitename.com');
Showing 4 lines of 5 total lines in this snippet.