Changed or Update Username

When the candidate update his/her email address, here's how to edit/update the username:

• Find out the database name and connect to it
• Go to db_candidates table
• Search first_name = the first letter of the firstname plus '%' example: B% and last_name = example: Shaw
• Look for the email then copy the email to the username
• Copy the id and go to ticket
• Response by pasting the candidate id and and paste the change username