How to find and replace string in MYSQL Database for a particular string only

Question

I want to replace a particular string in mysql database, i am using this query :

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

however what this query does is where it find raj it will replaces by rajesh for e.g if there is a string raju in databse after running this query raju becomes rajeshu which i dont want. i want a query which matches the replace string exactly means after running a query only 'raj' should get replaced with 'rajesh' and 'raju' should remain as is.. can someone please help??

Altmish-E-Azam · Accepted Answer · 2014-12-17 07:11:03Z

2

Try below 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 %';

answered Dec 17, 2014 at 7:11

Altmish-E-Azam

1,5732 gold badges13 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ankit Avlani · Accepted Answer · 2014-12-17 09:33:12Z

2

Try this 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'

edited Dec 17, 2014 at 9:33

Ankit Avlani

1295 bronze badges

answered Dec 17, 2014 at 7:52

codemaniac

2602 silver badges14 bronze badges

Comments

Saharsh Shah · Accepted Answer · 2015-12-23 10:50:00Z

2

This query works for me:

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

edited Dec 23, 2015 at 10:50

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

answered Dec 17, 2014 at 7:09

Ankit Avlani

1295 bronze badges

1 Comment

Altmish-E-Azam Over a year ago

If name like this `raj kumar rajan'?

Saharsh Shah · Accepted Answer · 2014-12-17 06:45:46Z

0

Try this:

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

edited Dec 17, 2014 at 6:45

answered Dec 17, 2014 at 6:36

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Collectives™ on Stack Overflow

How to find and replace string in MYSQL Database for a particular string only

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related