Finding large entries in wp_options and wp_post_meta tables

5/3/2017 - 1:18 PM

SELECT * FROM wp_options ORDER BY LENGTH(option_value) DESC
SELECT * FROM wp_postmeta ORDER BY LENGTH(meta_value) DESC

Cacher is the code snippet organizer for pro developers