Extend the wp_users table

There are far better ways of doing this. Instead of modifying the user table, make use of User Meta. It has a dedicated table, and works the same way as post meta, but for users.

  • add_user_meta
  • get_user_meta
  • update_user_meta

There are many tutorials explaining how to add additional fields to the user profile using User meta to store them, and it’s how a lot of standard data is stored already, such as the positions of boxes on the dashboard when you drag them around, how many posts to show at once in the edit screen, or which popups you’ve clicked dismiss on

Related Posts:

  1. Select Multiple meta_value from WP DB; Single Query
  2. In what part of the WordPress core does the users table and usermeta table get joined?
  3. Modify Database in Multi-Site wp_usermeta table
  4. How to Access wp_usermeta Data Immediately After a New User is Created
  5. Users table missing from Database [closed]
  6. Recovering the table wp_usermeta from users
  7. Storing user submitted forms [closed]
  8. wp_insert_user not creating account correctly when ID is manually set
  9. how add more field to wp user and save it to database
  10. Move Non-WordPress users table to WordPress database
  11. How to get the id of recently registered user from database?
  12. update multiple user meta field based on another meta field
  13. Multiple developers / editors working on a site in progress
  14. How many users can WordPress handle?
  15. How to track user progress?
  16. Performance tips for a large user base [closed]
  17. Efficiency on displaying random authors based on large database
  18. What’s the most efficient database method to add and query usermeta?
  19. How to use user table of a different database for WordPress users?
  20. Subscribers to posts
  21. Set Display Name to first and last name (phpmyadmin SQL Query)
  22. update_user_meta() does not work
  23. Is it possible to store visitors IPs in wp_postmeta table?
  24. Getting all the users who have author privilege
  25. Which is more efficient? Using usermeta, or creating a new MySQL table?
  26. Does WordPress always create unique passwords?
  27. User Last Login Sort Column
  28. A field with dashes in the slug [closed]
  29. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  30. Check if column exists for one table in DB
  31. Change WordPress prefix for only one table?
  32. Best way to tell if a user account is active, using the database only
  33. Using GROUP CONCAT in my-sql query with wp_usermeta table
  34. wp_get_current_user always returns 0 continued
  35. Is it safe to delete unnecessary user metadata?
  36. How to replicate a user plugin made table value, to this user’s custom meta table value?
  37. Is there a smart way to obtain a list of only some selected user meta data?
  38. How can i customize the export personal data file?
  39. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  40. WordPress Database Huge wp_usermeta Table
  41. Import users from old WP site to new one
  42. Logins from WP users table use on another page
  43. MS Access to manage WordPress Database
  44. 2 WordPress sites with 2 databases but sharing the same users
  45. Convert user passwords to MD5?
  46. What can I do when an outside party hacks into my weblog and changes my display name?
  47. Does WordPress store the username as a primary key in the database?
  48. Is there a way to execute a php script outside WordPress?
  49. multiple wordpress installation with shared usertable on an different database
  50. Best practice to import user base (subscribers) from one website to another?
  51. Share users across multiple sites on same database, but with different domains
  52. Some weird users in database
  53. How to delete a particular row in a database table
  54. I cannot find the difference between these wp_capabilities values in wp_usermeta
  55. Regenerate user_nicename column
  56. Buddypress avatar image in database [closed]
  57. WordPress where clauses in db select
  58. Select From wpdb – Author/User Directory page
  59. Can’t log into wordpress site – I have made a new user and still cant access
  60. Need help with creating a searchable user data by name or specific number like ID
  61. Compare User meta_value with Product meta_value
  62. Best Practice? – Saving multiple Values as Serialized Data / Saving each Value per Row / Dedicated Table
  63. Migrate Users From laravel to wordpress
  64. Join Query on WP_USERMETA Table
  65. Display user data in numbered list
  66. User input to database
  67. generate PDF from member information
  68. Change user_nickname for author page link
  69. how restrict user to give star ratings once for a post?
  70. create a table using user meta custom data
  71. How to save dropdown slection by a user in the DB
  72. How to get specific table by current user login
  73. get_user_meta and umeta_id
  74. Hash user emails in database?
  75. Changed meta_key value in structures, now dashboard shows zero users
  76. What WordPress file is saving new users to database
  77. Get id from database
  78. Preventing concurrent update of data
  79. WordPress sync with phpbb
  80. Let users register weight each day and save it in DB
  81. import (migration) user database to wp-users
  82. Calling update_user_meta inside of another function doesn’t work
  83. Import Excel (or csv) Table with user-data as subscribers to wordpress
  84. What is best for saving lot of extra detail of user?
  85. WP Multisite Users Not Linking
  86. wp_usermeta key problem
  87. Query a meta key using an array of values where the database value is a string
  88. Lost the `wp_options` table: what’s the best way to restore the site?
  89. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  90. How might I retrieve a featured post image from an external WP site and display it as a link back?
  91. Hide a user from WordPress
  92. Is a direct or import approach safer for migration into WordPress?
  93. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  94. Why user_pass column in wp_users table is varchar(64)
  95. Using $wpdb | checking entered email against existing emails in db
  96. wp-cli: Error establishing a database connection: undefined constant DB_USER
  97. Outputting query results
  98. Search Character Set Problem
  99. How to fix Uploaded to this post option to see group of images uploaded to a post?
  100. Order of search results based off of a backend custom field and also in alpha order