How to find and replace a row in a MYSQL database for a specific row only

Question

I want to replace a specific row in mysql database, I use this query:

UPDATE users SET name = replace (name, 'raj', 'rajesh')

however, what this request does is where it will find raj, it will replace rajesh for example, if there is a raju line in the databse after running this raju request it becomes rajeshu, which I don't want. I want a query that matches the replace string to exactly mean that after running the query, only "raj" should be replaced by "rajesh" and "raju" should remain as it is .. can someone help?

Answer 1

This query works for me:

 UPDATE users SET name = replace(name,'raj','rajesh') WHERE name = 'raj' 

Answer 2

Try the query to replace raj with rajesh

 update users set name=replace(name,' raj ',' rajesh '); 

OR

  update users set name=replace(name,'raj ','rajesh ') where name like '% raj %'; 

Answer 3

Try it, it will definitely work for you.

 update users set name=replace(LOWER(name),'raj','rajesh') where name like 'raj %' OR name like '% raj %' OR name = 'raj' 

Answer 4

Try the following:

 UPDATE users SET name = 'rajesh' WHERE name = 'raj';