mysql replace method plus java

Question

i knew how to replace a single value all over the field by using REPLACE method like

   UPDATE `table` SET `field` = REPLACE(`field`, `string`, `anothervalue`)

but what if i have to replace different values by different other things in the same field e.g "," is to replace by "." and "/" is to replace by white space " " and "hons" is to replace by "honours" in the same field, can i do it in a single query?

juergen d · Accepted Answer · 2013-02-12 14:01:51Z

2

You can cascade the replace

UPDATE `table` 
SET `field` = replace(replace(replace(`field`, ',', '.'), '/', ' '), 'hons', 'honours')

answered Feb 12, 2013 at 14:01

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

Comments

Sashi Kant · Accepted Answer · 2013-02-12 14:02:04Z

2

UPDATE `table` 
SET `field` = REPLACE(REPLACE(REPLACE(`field`,'/',' ') ',','.') , 'hons', 'honours')

answered Feb 12, 2013 at 14:02

Sashi Kant

13.5k9 gold badges50 silver badges71 bronze badges

Collectives™ on Stack Overflow

mysql replace method plus java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related