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. Disable emojicons introduced with WP 4.2
  17. How to remove a filter that is an anonymous object?
  18. WordPress hooks/filters insert before content or after title
  19. How to add defer=”defer” tag in plugin javascripts?
  20. add_action(), add_filter() before or after function
  21. apply_filters(‘the_content’, $content) vs do_shortcode($content)
  22. How do filters and hooks really work in PHP
  23. Trouble understanding apply_filters()
  24. What is the very earliest action hook you can call?
  25. How would one modify the filtering Gutenberg applies to pasted content?
  26. How can I modify the WordPress default widget output?
  27. Add custom options to the wplink dialog
  28. Remove classes from body_class
  29. what is __return_false in filters
  30. Explanation for apply_filters function and its variables
  31. Gutenberg: Is there a way to know if current block is inside InnerBlocks?
  32. How to reorder billing fields in WooCommerce Checkout template? [closed]
  33. Insert HTML just after tag
  34. the_content and is_main_query
  35. Changing WooCommerce Display Price Based on User Role & Category [closed]
  36. How to add a custom CSS class to core blocks in Gutenberg editor?
  37. How to show page content in feed?
  38. wp_headers vs send_headers. When to use each?
  39. Filter any HTTP request URI?
  40. How to Pass External Variables to Filters/Actions
  41. Filter by one custom field, order by another?
  42. Not able to change wp_title using add_filter
  43. Update post counts (published, draft, unattached) in admin interface
  44. How to appending to the_content using add_filter with custom post type?
  45. Query WP REST API v2 by multiple meta keys
  46. No filter of code on switch from html to visual editor, how?
  47. Sanitize and data validation with apply_filters() function
  48. How to modify posts_where filter only for the search query
  49. How to hook a filter to catch get_post_meta when alternate a custom field output?
  50. How to get shortcode’s input values inside a filter?
  51. Removing Image and Caption Dimension Attributes
  52. How to wrap oEmbed-embedded video in DIV tags inside the_content?
  53. How many filter/action hooks are healthy?
  54. WordPress 3.9 – Trouble Editing TinyMCE 4.0
  55. Changing JPEG compression depending on image size
  56. How to add filter with 2 args?
  57. Why is javascript allowed in my post content?
  58. How to use update_{$meta_type}_metadata filter to modify meta value
  59. How to wrap an element around an iframe or embed in content automatically?
  60. Filter specific shortcode output?
  61. WordPress Internal @ Mentions
  62. How to add headers to outgoing email?
  63. Earliest hook to reliably get $post/$posts
  64. Insert new element to array with add_filter
  65. LESS CSS enqueue_style with add_filter to change rel attribute
  66. Is it possible to filter comments in a post so a user can only see the comments they have written?
  67. How to pass/get data to/from the WooCommerce data-product_variations object?
  68. Remove Editor From Homepage
  69. How to modify Contact Form 7 Success/Error Response Output [closed]
  70. Where to hook into post content?
  71. What does (10, 2) mean when used with add_filter
  72. Filter translations (gettext strings) on specific admin pages
  73. Filter username field on registration for profanity and unwanted words
  74. Clarification on filters and hooks
  75. remove_filter( ‘the_content’, ‘wpautop’ ); only for certain post types
  76. At what priority does add_filter overwrite core functions?
  77. Valid characters for actions, hooks and filters
  78. is it possible to add “extra” table nav to edit-tags.php screens?
  79. Advanced Custom Fields and Yoast SEO keyword analysis [closed]
  80. Adding a filter to qTranslate to change display of language chooser
  81. Insert Custom HTML After Shortcode
  82. Modify links when inserted by WYSIWYG editor
  83. Is there a way to add another row to the tinyMCE kitchen sink toggle?
  84. How to hook into unregistering a widget instance?
  85. How to check if a hook is hooked or not?
  86. Completely strip any hidden formatting when pasting into TinyMCE
  87. How can I extend the Gutenberg table block transform to allow colspans/rowspans on pasted table elements?
  88. How to add filter to __() and _e()?
  89. Remove description from on Home
  90. Editing ‘Password Reset’ E-mail
  91. Is it possible to use object in add_action?
  92. add_filter and changing output captions of image gallery
  93. Passing Additional Parameters to add_filter Callable
  94. What hook do I use to edit the post statuses option in admin?
  95. How can I add an Author filter to the Media Library?
  96. Add whitespace between Chinese and other letters
  97. Filter hook before create order WooCommerce
  98. Check if a filter or function has been already been called
  99. Modify WordPress Rest Api Request/Response
  100. How to add some custom HTML into wordpress admin bar?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)