joey-pie
8/10/2016 - 11:50 AM

Query to change user emails in the wp users table sequentially to ensure all are different

Query to change user emails in the wp users table sequentially to ensure all are different

sequential_row_changes.sql
content_copyfile_download
SELECT @i:=0;
UPDATE wp_users SET user_email = CONCAT("test", @i:=@i+1, '@pie.co.de');