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.