UPDATE users SET name = CONCAT(name, "_1") WHERE name IN (SELECT name FROM users GROUP BY name HAVING count > 1);