Duplicate records in SQL (duplicating user accounts/privilidges with unique keys and usernames)

INSERT
INTO
users
SELECT
‘newUsername’
,somecolumn
,someothercolumn
,yetanothercolumn
FROM
users
WHERE
username = ‘oldUsername’