Loading

Rename user in DB

Chap Chap

4y746SQL

Hi,

I have a list of ''chat users'' in my DB and I want to rename a specific user if possbile. I am using the SELECT * FROM users WHERE nickname='username' and I am stuck here with the next query that needs to be written in order to change nickname. Can anyone help me with this ?

Best.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
use update
update users set nickname='newName' WHERE nickname='username'
Vinitha T4y ago
To Rename Vinitha to Vini:

Table:

Query to Rename:

UPDATE Employee set EmployeeName='Vini' where EmployeeName='Vinitha';

Table after Renaming:
Srinivasan Ramamoorthi4y ago
You can create a update subquery and update the user name meeting the select criteria