Delete orphaned user meta data

# Deletes user meta data that does not have a matching user ID.
# Script as written assumes "wp_" table stem. Change the stem if necessary.
DELETE FROM wp_usermeta
WHERE NOT EXISTS (
  SELECT * FROM wp_users
    WHERE wp_usermeta.user_id = wp_users.ID
);

Not sure what to do with this code?

You're not a "coder" and don't know what to do? Don't worry! Code Snippets are the basic building blocks of WordPress customization, and once you know the basics, they are simple to use.

Here are some free articles to get you started:

• Using Code Snippets from the Site
• Using a code snippets plugin
• The functions.php File
• Create a plugin file for custom functions
• Create a child theme
• Do not modify plugin files!

For "hands on" help, consider a plugin support subscription or the Pro Bundle.