Filter users by custom colum not meta key

This isn’t possible with custom table columns, and you should avoid and move away from custom modifications to WP Core tables. Instead, store this data in user meta instead of custom table columns.

When you next update WordPress, if the database schema will change, WP will adjust the tables to match, destroying your custom columns and all the data they contain ( or the update will fail ).

The API you attempted to use was intended for these user meta values, you can adjust user meta just like post meta:

  • add_user_meta
  • update_user_meta
  • get_user_meta
  • delete_user_meta

You can simplify your code by using these instead, it will allow you to eliminate the raw SQL needed to adjust the table and save/fetch information, and allow you to use WP APIs as intended.

And remember, never modify WP Core to change WP, that includes the table columns.

Related Posts:

  1. How to filter users on admin users page by custom meta field?
  2. How to bulk delete all users with no posts?
  3. How can I add information underneath the user’s name on the users.php page?
  4. How may I filter get_users() similarly to pre_get_posts?
  5. Get current user data
  6. How to replace username with email address in users table
  7. How would I be able to use a font awesome icon as a user’s avatar?
  8. Register new user, assign custom role then send email
  9. How can i filter wordpress users by custom feild?
  10. How to pass a variable between filter/action functions?
  11. WP_Query filter by custom meta
  12. WordPress: Issue with filtering users using date range
  13. Custom registration field to SQL database
  14. How do you disable the verification process of user email changes?
  15. Filter and manipulate the get_current_user() function
  16. Not able to change wp_title using add_filter
  17. How to hook a filter to catch get_post_meta when alternate a custom field output?
  18. Changing JPEG compression depending on image size
  19. How to add headers to outgoing email?
  20. LESS CSS enqueue_style with add_filter to change rel attribute
  21. Advanced Custom Fields and Yoast SEO keyword analysis [closed]
  22. Insert Custom HTML After Shortcode
  23. Is there a way to add another row to the tinyMCE kitchen sink toggle?
  24. Remove description from on Home
  25. add_filter to youtube embeds?
  26. How can I detect if a user changes their password?
  27. SSL certificate for the host could not be verified
  28. Store source permalink on XMLRPC calls
  29. How to limit the pages displayed for choosing parent page on page attribute’s menu?
  30. Moving sharedaddy buttons (in Jetpack) to the top of a post?
  31. WordPress RSS feed – filter RSS content by custom field value
  32. What is the filter hook for custom fields content?
  33. Filter keywords from search query
  34. Add class to woocommerce checkout body based on filter [closed]
  35. changing variable through filters or action hooks
  36. filter the_title problem in nav
  37. Changing Gutenberg / WP block editor width only on pages, not posts or other taxonomies
  38. How to replace any occurence of Gravatars with a local placeholder image?
  39. Ignore dots when searching in the media library?
  40. How to change the blog title with add_filter? details below
  41. How To Get User Data in Callback Function for pre_user_nicename?
  42. What’s the best way to split admin-only functionality in the theme’s functions.php file?
  43. Where is this inline CSS code [closed]
  44. the_content filter – checking the post
  45. Which built-in WordPress files are safe to edit?
  46. Why won’t my preg_replace work with content_save_pre?
  47. How do I target a single page to modify the comment form of only that page?
  48. How Does comment_author Filter Work?
  49. Add ‘data-text’ attribute to TagCloud HTML
  50. Insert term when page is published – avoid duplicates after edits
  51. When does a function assigned to the content_filtered_edit_pre filter hook fire?
  52. Capture post content before page renders
  53. Empty string supplied as input when parsing content
  54. How can I remove the kses filters when saving a specific post type ? (it breaks my JSON)
  55. Remove_action does not work
  56. How to access plugin variables from theme templates without using globals?
  57. How to pass variables to custom filter from multiple functions
  58. WooCommerce Custom Product Validation [closed]
  59. Make WP not format code, not insert line breaks in between tags
  60. add img class to native wordpress galleries
  61. the_content filter together with require_once returns 1 instead of the content of the included file
  62. Missing Argument 2 for apply_filter
  63. How to get a single hook from wp_head()?
  64. WP filter to alter admin CSS styles?
  65. How to apply a filter to an ACF wysiwig editor field output?
  66. Why this filter hook is not working when passing parameters?
  67. Is it possible to bind a function to a filter hook via Ajax?
  68. Change the template when the user is not logged in using page_template filter (it does not work)
  69. Hide Posts In Back-end/Admin Based On User’s (Pseudo) Privileges Controlled by ACF
  70. Filter Pages by Custom Field (ACF) in admin area
  71. Filter posts by meta data using custom query
  72. Remove tags without a specific meta key from “choose from the most used tags”
  73. Which Filter Do I Use To Modify The Subject Of The Retrieve Password Notification Email?
  74. Register users by e-mail
  75. automatic title through filter
  76. Filter causing loss of _wp_attachment_metadata
  77. Buddypress Filter Multiple Activities [closed]
  78. How can I tranlslate post date in italian?
  79. Having wp-admin on different domain
  80. Use a functions in functions.php to remove a string for template theme
  81. oembed_dataparse filter not running at all for standard YouTube embed
  82. Action for opening attachment or manipulating all attachment links
  83. Filter wp_mail based on content type
  84. Add filter conditionally to a page
  85. Remove the post_content search from WHERE clause (and CONCAT sql function)
  86. mu-plugins body_class filter not working
  87. Post filter Month dropdown at front-end like wordpress backend
  88. shortcode function outputs multiple anchor tags
  89. WP Dashboard -> Posts-> Filter by Category -> Form Method Change : Which Hook
  90. Show child theme for users on specific IP
  91. Remove action added from class
  92. wp.getPosts with status = ‘trash’ using node.js
  93. Is there a way to overwrite a filter used in canonical.php?
  94. Adding an orderby filter, casting postmeta with multiple keys
  95. Identify admin/logout and more filters
  96. confusion with add_filter
  97. post->post_content filter
  98. How to create a list of terms who’s posts also have a predefined external term?
  99. How to change this WP logo and posts url in block editor?
  100. Limit total tags in the_content