If your code works, use it.
It ought to be possible to do this in pure SQL and that might even be more efficient, but don’t. Rather, unless you are experiencing identifiable issues using the Core code– timeouts, for example– and cannot solve them, don’t resort to a pure SQL solution.
The reason is that if the database structure or other Core functionality changes, then code based on the Core functions should (probably) survive. Code based in pure SQL might not.
Related Posts:
- Editor can create any new user except administrator
- Confirmation required on email change
- get_current_user_id() returns 0?
- List users by last name in WP_User_Query
- Email user when password is reset by admin
- How to work around “that email address has already been used” error?
- How to redirect a specific user after log-in?
- How to Prevent deleting user accounts in WordPress Back-end?
- LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
- Upload gravatar in WP profile?
- How to stop a user from updating the post date
- Recover the user that have been deleted
- determining if the user is logged in
- Adding a photo to each WP user
- WordPress edit_user_profile_update update secondary role
- How to check that if current user (ID) has posts or not
- How to get the Role Name of the current user? (WordPress)
- how to get recent registered author id?
- set_role has no effect
- Why don’t first_name and last_name appear when you print_r the WP_User object?
- How to use search_columns in WP_User_Query?
- Get users only if Gravatar is specified
- WordPress to use Drupal users’ credentials
- Authenticate with a Rails app?
- How do I list in the backend all users that were assigned to a custom role?
- Send Email to Users after Deleting Account
- How to add local users to wordpress without email password?
- Call to undefined function wp_insert_user()
- Suddenly all emails in User have [email protected]
- *wpupdateuser* user_login in my WordPress database
- Updating user meta
- Changing a username
- Change the user_login at registration
- Are User Levels Still Currently Used?
- How to add a user profile page to frontend?
- Error: How to allow the “contributor” to upload media in wordpress
- Search Users base on meta_value & meta_key
- Favorite taxonomy archive page?
- Removing all trace of member profiles
- WordPress API for search
- Fix permissions for users role
- Redirect subscribers to last viewed page after log-in
- User Meta Data in a Sortable Table
- Are there mutiple ways to get usernames (as a hacker)
- Rest api return all users (even without content) to all users
- Column Sorting Code on users.php
- How can I allow an User to publish only 5 posts per month?
- How to stop redirect if user is already on correct page (Using Case Switch)
- search users using user name and user meta in wordpress
- How to activate the user search
- How change user type from contributor to author
- WordPress Login Customization for External Authentication
- How to allow registered users to submit the form only 5 times per day?
- Is there any action /filter hook I can use to disable login for some user role?
- Preventing user enumeration: which logic is better?
- Create a “user log”
- How can I do a url redirect to include a wordpress username?
- WP_User_Query combining role and ids
- WordPress current month users
- Allow Users to Modify Some Values of Assigned WordPress Pods [closed]
- Make new users automatically approved
- Adding fields to the “Add New User” but the form data not saved into DB
- Admin approval for editing user profile
- Using a custom field value as current users name [closed]
- How can I set wp_dropdown_users so that it shows only authors?
- What does “link” refer to when you delete a user?
- WP Create User – Preventing repeated information
- Editor role can only create/edit/delete users who have one of two roles
- Can’t add user- wrong message “this user name is invalid because it uses illegal characters”
- set automatically email address for WordPress users
- WordPress 5.8 – Hide or Remove personal fields from admin Profile page
- hide user is currently editing warning in admin post page
- Restricting wordpress login sessions for a web app
- change user password REST API
- Find count of WordPress users by role and search string for user name
- Append USER ID to an outbound link?
- How do I add profile fields in specific section?
- fine-grained capabilities for user related capabilities
- How to destroy all user sessions via WP-CLI
- Is a list of user names or IDs in a custom profile field the best way to create a followers list?
- Custom User Role: Can Edit Own Page, Cannot Create New
- How to restrict Admin from creating new users from Add new user screen in dashboard to only of one domain?
- Get meta key with value for user
- Redirect current user
- Display Users and user url’s
- custom login form, guide me
- Edit dashboard based on user ID
- is_user_logged_in() not working after domain change
- Get the author registration date in the header.php file
- Front end login and page restriction
- How i will get the images of highest scored users?
- Designing a member area on my site
- view and update form only for registered users
- Redirect based on log-in status per JavaScript
- i need to let a user to add a role from a frontend form
- Integrating Facebook Registration (and Login) on a WordPress page
- WordPress C# User Login
- Create users from frontend without password
- How to get user contact info
- Why does a super admin on multi site get a rest_user_invalid_id error code when requesting user details through REST?