MySQL Forums
Forum List  »  Newbie

Re: Change username in table
Posted by: Lee Matthews
Date: April 06, 2021 04:13PM

I figured it out using this query:
UPDATE `table_user_allowlist` SET `username` = REPLACE(`username`, '@domain.com', '');

Thanks for your help.

Options: ReplyQuote


Subject
Written By
Posted
April 06, 2021 01:26PM
Re: Change username in table
April 06, 2021 04:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.