Skip to content

Instantly share code, notes, and snippets.

@caiovncius

caiovncius/Update WP users to fake data.sql

Created January 29, 2022 16:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save caiovncius/b6448d3d10e5f9514581b1231bbe8c4b to your computer and use it in GitHub Desktop.
Save caiovncius/b6448d3d10e5f9514581b1231bbe8c4b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Update WP users to fake data.sql
UPDATE wp_users SET user_nicename = CONCAT(LEFT(user_login, INSTR(user_login, '@')), '') WHERE ID = 0;
UPDATE wp_users SET user_login = CONCAT(LEFT(user_login, INSTR(user_login, '@')), 'example.test') WHERE ID = 0;
UPDATE wp_users SET user_email = CONCAT(LEFT(user_login, INSTR(user_login, '@')), 'example.test') WHERE ID > = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment