Skip to content

Instantly share code, notes, and snippets.

@crstauf

crstauf/wp-expired-transient-timeouts.sql

Created June 13, 2018 05:36
Show Gist options
  • Save crstauf/0626f9e9ac3f4492fb520bc3d36b98f0 to your computer and use it in GitHub Desktop.
Save crstauf/0626f9e9ac3f4492fb520bc3d36b98f0 to your computer and use it in GitHub Desktop.
Download ZIP
SQL query to select expired WordPress transient timeouts
Raw
wp-expired-transient-timeouts.sql
SELECT `option_name`, `option_value` FROM `wp_options` WHERE `option_name` LIKE '\_transient\_timeout\_%' AND CAST(`option_value` AS UNSIGNED) < UNIX_TIMESTAMP() ORDER BY `option_value`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment