Deleting unused user metakey

  • Resolved pandglobal

    (@pandglobal)


    5 years, 1 month ago

    The meta keys are
    billing_country
    billing_state
    billing_city
    AUTHCODE1
    AUTHCODE2

    The above are the metakeys, and i want to delete them entirely my my usermeta. Since am not using them any more and the wocommerce plugin that created them is no longer installed.

Viewing 1 replies (of 1 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Something like this entered in the SQL tab of PHPYADMIN

    DELETE FROM wp_usermeta WHERE wp_usermeta.meta_key like 'billing_country';
    DELETE FROM wp_usermeta WHERE wp_usermeta.meta_key like 'billing_state'
    and so on.

    Be sure to export (backup) the table first.

    Log in to your hosting control panel to access PHPMYADMIN.

Viewing 1 replies (of 1 total)
  • The topic ‘Deleting unused user metakey’ is closed to new replies.