Skip to content

Instantly share code, notes, and snippets.

@oakwoodgates

oakwoodgates/gist:667a82f939e4e29f7554d3b7a9914096

Last active October 6, 2022 06:12
Show Gist options
  • Save oakwoodgates/667a82f939e4e29f7554d3b7a9914096 to your computer and use it in GitHub Desktop.
Save oakwoodgates/667a82f939e4e29f7554d3b7a9914096 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT *
FROM `wp_usermeta`
WHERE `meta_key` LIKE '%thing%'
ORDER BY `meta_key` DESC
LIMIT 1500
DELETE FROM `wp_usermeta`
WHERE `meta_key` LIKE '%thing%'
LIMIT 1500
SELECT *
FROM `wp_posts`
LEFT JOIN some_table ON wp_posts.ID = some_table.ID
WHERE some_table.some_value LIKE 1
LIMIT 50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment