The obvious method would be to write a custom WP-CLI script to run through the table, extract the first and last names, use sanitize_title to create a new nicename and update the record. You’d also need to copy the first and last names in wp_usermeta as you mention, at the same time.
I’m not sure I’m telling you anything you don’t already know here.
Related Posts:
- Multiple developers / editors working on a site in progress
- How many users can WordPress handle?
- How to track user progress?
- Performance tips for a large user base [closed]
- Efficiency on displaying random authors based on large database
- Extend the wp_users table
- How to use user table of a different database for WordPress users?
- Subscribers to posts
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Select Multiple meta_value from WP DB; Single Query
- Getting all the users who have author privilege
- Does WordPress always create unique passwords?
- In what part of the WordPress core does the users table and usermeta table get joined?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Modify Database in Multi-Site wp_usermeta table
- Change WordPress prefix for only one table?
- wp_get_current_user always returns 0 continued
- Is there a smart way to obtain a list of only some selected user meta data?
- How can i customize the export personal data file?
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- Import users from old WP site to new one
- How to Access wp_usermeta Data Immediately After a New User is Created
- Logins from WP users table use on another page
- MS Access to manage WordPress Database
- 2 WordPress sites with 2 databases but sharing the same users
- Convert user passwords to MD5?
- Does WordPress store the username as a primary key in the database?
- Is there a way to execute a php script outside WordPress?
- multiple wordpress installation with shared usertable on an different database
- Best practice to import user base (subscribers) from one website to another?
- Share users across multiple sites on same database, but with different domains
- Users table missing from Database [closed]
- Some weird users in database
- How to delete a particular row in a database table
- Recovering the table wp_usermeta from users
- Storing user submitted forms [closed]
- WordPress where clauses in db select
- wp_insert_user not creating account correctly when ID is manually set
- Select From wpdb – Author/User Directory page
- Can’t log into wordpress site – I have made a new user and still cant access
- Need help with creating a searchable user data by name or specific number like ID
- Migrate Users From laravel to wordpress
- Display user data in numbered list
- User input to database
- how add more field to wp user and save it to database
- Move Non-WordPress users table to WordPress database
- Change user_nickname for author page link
- how restrict user to give star ratings once for a post?
- create a table using user meta custom data
- How to get the id of recently registered user from database?
- How to save dropdown slection by a user in the DB
- How to get specific table by current user login
- update multiple user meta field based on another meta field
- Hash user emails in database?
- Changed meta_key value in structures, now dashboard shows zero users
- What WordPress file is saving new users to database
- Get id from database
- WordPress sync with phpbb
- import (migration) user database to wp-users
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- WP Multisite Users Not Linking
- get_results using wpdb
- Transient RSS feeds in wp_options not removed automatically?
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- Database location in WordPress
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- Change SQL get_results to search for posts with custom term in custom taxonomy
- How to update BuddyPress xprofile fields programmatically? [closed]
- How to diagnose and keep in check encoding issues?
- Add search Value to wp_list_table pagination
- stdObject stored in database. How does one convert it to usable format?
- I have a table I created, how do I make a form for a user to filter the data?
- Does WordPress ever need multiple databases?
- Creating user relationships
- Multiple wp_options tables to share content across installs
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Permit Login if table row exists
- custom user role wordpress – grant guest access to edit.php without insert/update/delete
- Saving zero as meta value
- How to convert srcset links from https to http?
- Sharing users across multiple sites, each on their own database
- Image link issues after importing a database backup to my local web server
- multiple wordpress installs w/shared user database but separate content databases
- Updating seperate database when post attachment is changed
- add featured image dialog box disappear
- WordPress Database – wp_usermeta and the correct number of session_tokens rows
- How to get a list of articles related to a particular category from my other WordPress website?
- A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
- How do I update a WordPress wp_postmeta meta_value that contains many options
- How can I get $wpdb to show MySQL warnings?
- About wp database hooks (error establishing connection)
- Share WordPress Database
- DB access blocked when initializing WP externally
- Site does not work right, pages not showing up, even for root admin
- WordPress: Interact with Database Query Data and Login
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- WordPress database connection failed, while mysql client is working [closed]