MySQL Forums
Forum List  »  MySQL Query Browser

Replace username with Firstname + '.'+lastname
Posted by: Harish Shelat
Date: May 03, 2011 04:28PM


I am new to mysql. I have installed mysql and it is working. I have table called customers. This table has field name username (login name). It has also fieldname like firstname, Lastname, etc. This username is like 'abcccd'. I like to replace all usersnames with firstname + '.' Lastname. I tried the command 'Concate_ws but it did not work. How can I replace current username by their firstname.(period)lastname? I do not want to go through one by one record and manually update it.



Edited 1 time(s). Last edit at 05/03/2011 05:50PM by Harish Shelat.

Options: ReplyQuote

Written By
Replace username with Firstname + '.'+lastname
May 03, 2011 04:28PM

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.