Query Helper Querie #SQL

sql-queries.js

Search and Replace mysql
UPDATE t
     set url = REPLACE(url, 'http:', 'https:')
     WHERE url LIKE '%http:%';


update wp_postmeta
     set meta_value = REPLACE(meta_value, 'https:', 'http:')
     WHERE meta_value LIKE '%https:%';

#ONLY_FULL_GROUP_BY Fix
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));