Option table queries

By.

min read

My profile

Share this:

SELECT *, LENGTH(option_value) as leng, concat(LENGTH(option_value) / 1000, ‘ KB’) FROM `wp_options` ORDER BY leng DESC

SELECT *, LENGTH(option_value) as leng, concat(LENGTH(option_value) / 1000, ‘ KB’) FROM `wp_options` WHERE autoload = ‘yes’ ORDER BY leng DESC

SELECT CONCAT( SUM( LENGTH( option_value ) ) /1000, ‘ KB’ )
FROM `wp_options`
WHERE autoload = ‘yes’

Share this:

Leave a Reply

Your email address will not be published. Required fields are marked *