adtaylor · January 7, 2014 13:31
diff --git a/wordpress_lorem_finder_snippets.sql b/wordpress_lorem_finder_snippets.sql
 SELECT * from `wp_posts` 
 WHERE `post_content` RLIKE 
 'Lorem|ipsum|dolor|luptatum|molestiae|dolorem|mnesarchum|blandit|ocurreret|Nullam|graeci|appellantur|sensibus|splendide|vituperatoribus|dicam|periculis|dignissim|aliquam|philosophia|iusto|utroque|oportere|utinam|eloquentiam|definitiones|tacimates|meliore|reformidans|Graecis|constituto|assum|atomorum|recteque|Melius|maluisset|solum|ullum|habemus|ponderum|luptatum|honestatis|torquatos|contentiones';

 SELECT * from `wp_posts` WHERE `post_excerpt` RLIKE
 'Lorem|ipsum|dolor|luptatum|molestiae|dolorem|mnesarchum|blandit|ocurreret|Nullam|graeci|appellantur|sensibus|splendide|vituperatoribus|dicam|periculis|dignissim|aliquam|philosophia|iusto|utroque|oportere|utinam|eloquentiam|definitiones|tacimates|meliore|reformidans|Graecis|constituto|assum|atomorum|recteque|Melius|maluisset|solum|ullum|habemus|ponderum|luptatum|honestatis|torquatos|contentiones';

 SELECT * from `wp_posts` WHERE `post_title` RLIKE
 'Lorem|ipsum|dolor|luptatum|molestiae|dolorem|mnesarchum|blandit|ocurreret|Nullam|graeci|appellantur|sensibus|splendide|vituperatoribus|dicam|periculis|dignissim|aliquam|philosophia|iusto|utroque|oportere|utinam|eloquentiam|definitiones|tacimates|meliore|reformidans|Graecis|constituto|assum|atomorum|recteque|Melius|maluisset|solum|ullum|habemus|ponderum|luptatum|honestatis|torquatos|contentiones';

 SELECT * from `wp_postmeta` WHERE `meta_value` RLIKE
 'Lorem|ipsum|dolor|luptatum|molestiae|dolorem|mnesarchum|blandit|ocurreret|Nullam|graeci|appellantur|sensibus|splendide|vituperatoribus|dicam|periculis|dignissim|aliquam|philosophia|iusto|utroque|oportere|utinam|eloquentiam|definitiones|tacimates|meliore|reformidans|Graecis|constituto|assum|atomorum|recteque|Melius|maluisset|solum|ullum|habemus|ponderum|luptatum|honestatis|torquatos|contentiones';
	SELECT * from `wp_posts`
	WHERE `post_content` RLIKE
	'Lorem\|ipsum\|dolor\|luptatum\|molestiae\|dolorem\|mnesarchum\|blandit\|ocurreret\|Nullam\|graeci\|appellantur\|sensibus\|splendide\|vituperatoribus\|dicam\|periculis\|dignissim\|aliquam\|philosophia\|iusto\|utroque\|oportere\|utinam\|eloquentiam\|definitiones\|tacimates\|meliore\|reformidans\|Graecis\|constituto\|assum\|atomorum\|recteque\|Melius\|maluisset\|solum\|ullum\|habemus\|ponderum\|luptatum\|honestatis\|torquatos\|contentiones';

	SELECT * from `wp_posts` WHERE `post_excerpt` RLIKE
	'Lorem\|ipsum\|dolor\|luptatum\|molestiae\|dolorem\|mnesarchum\|blandit\|ocurreret\|Nullam\|graeci\|appellantur\|sensibus\|splendide\|vituperatoribus\|dicam\|periculis\|dignissim\|aliquam\|philosophia\|iusto\|utroque\|oportere\|utinam\|eloquentiam\|definitiones\|tacimates\|meliore\|reformidans\|Graecis\|constituto\|assum\|atomorum\|recteque\|Melius\|maluisset\|solum\|ullum\|habemus\|ponderum\|luptatum\|honestatis\|torquatos\|contentiones';

	SELECT * from `wp_posts` WHERE `post_title` RLIKE
	'Lorem\|ipsum\|dolor\|luptatum\|molestiae\|dolorem\|mnesarchum\|blandit\|ocurreret\|Nullam\|graeci\|appellantur\|sensibus\|splendide\|vituperatoribus\|dicam\|periculis\|dignissim\|aliquam\|philosophia\|iusto\|utroque\|oportere\|utinam\|eloquentiam\|definitiones\|tacimates\|meliore\|reformidans\|Graecis\|constituto\|assum\|atomorum\|recteque\|Melius\|maluisset\|solum\|ullum\|habemus\|ponderum\|luptatum\|honestatis\|torquatos\|contentiones';

	SELECT * from `wp_postmeta` WHERE `meta_value` RLIKE
	'Lorem\|ipsum\|dolor\|luptatum\|molestiae\|dolorem\|mnesarchum\|blandit\|ocurreret\|Nullam\|graeci\|appellantur\|sensibus\|splendide\|vituperatoribus\|dicam\|periculis\|dignissim\|aliquam\|philosophia\|iusto\|utroque\|oportere\|utinam\|eloquentiam\|definitiones\|tacimates\|meliore\|reformidans\|Graecis\|constituto\|assum\|atomorum\|recteque\|Melius\|maluisset\|solum\|ullum\|habemus\|ponderum\|luptatum\|honestatis\|torquatos\|contentiones';