Locating all users metakey in database

  • Please how can i locate the user metakey called display_name in my database?
    And how can i use mySQL function in phpmyadmin to clear all values in that metakey for all users?

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

    (@sterndata)

    Volunteer Forum Moderator

    It’s in wp_users. See https://codex.www.ads-software.com/Database_Description

    I’m not sure what would happen if you clear that field. What are you trying to accomplish?

    The SQL to empty the field would be

    UPDATE wp_users SET display_name='';

    Again, why?

    Thread Starter pandglobal

    (@pandglobal)

    Actually thanks for the code, but i wasn’t targeting that very metakey, am only using it for illustrations, i have a custom metakey called date_ofbirth thats the one i will target.

    Please can i use set value option to make set the values to 0 instead of clearing it entirely.
    If so which SQL command can i use for set value?

    Thread Starter pandglobal

    (@pandglobal)

    Something like this should work?

    UPDATE wp_users SET display_name=’0′;

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Locating all users metakey in database’ is closed to new replies.