gladson

Sql	                                                    QuerySet	                                     Notes
SELECT count(*) FROM fruit	                      Fruits.objects.count()	                          table count
SELECT count(*) FROM fruit WHERE name=’Orange’        Fruits.objects.filter(name__exact=’Orange’).count() count with filter
SELECT * FROM fruit WHERE color is NULL	              Fruits.objects.get(color__isnull=True)	          filter by null
SELECT * FROM fruit WHERE color is NOT NULL	      Fruits.objects.get(color__isnull=False)	          filter by null
SELECT * FROM fruit WHERE name=’Apple’	              Fruits.objects.get(name__exact=’Apple’)	          case sensitive
SELECT * FROM fruit WHERE lower(name)=lower(‘Apple’)  Fruits.objects.get(name__iexact=’Apple’)            case in-sensitive
SELECT * FROM fruit WHERE name LIKE ‘App%’	      Fruits.objects.filter(name__startswith=’App’)       case sensitive LIKE
SELECT * FROM fruit WHERE upper(name) LIKE ‘APP%’     Fruits.objects.filter(name__ista

chuckreynolds

/* Use WP-CLI instead https://developer.wordpress.org/cli/commands/search-replace/ */

SET @oldsite='http://oldsite.com'; 
SET @newsite='http://newsite.com';
UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

/* only uncomment next line if you want all your current posts to post to RSS again as new */