Contents
Standard User Fields
ID – the User ID (the numeric one)user_login – the name based user loginuser_nicename – the name the user has chosen to be referred by, Usually ‘First Name’display_name – the full user nameuser_pass – the hashed passworduser_email – the User’s email addressuser_url – the User’s Websiteuser_registered – the date the user was registered on the website.
User Meta
These are not in wp_users, only in wp_usermeta which means if you either need to add .meta_value onto the field if you’re attempting a match, or if you’re using PHP, you need to use get_user_meta.
nickname– Nicknamefirst_name– First Namelast_name– Last Namedescription– Biographical information meta box.wp_capabilities– Stores the Role for the User in a serialized array. Any searches to match will require usingLIKEoperator. The value will be the short slug name for the role, ieadministrator,author,editor, etc.