MySQL REPLACE multiple values

Question

I have data in a column that is causing problems. There are multiple bad characters I need to remove. I'd like to do this in the query.

On this question: MySQL string replace

I see where I can SELECT REPLACE(string_column, 'search', 'replace') as url but this only works for example replacing a / with //

I need to replace / with // and also & with && for example in a single query. What is the best way to achieve this?

[*Can MySQL replace multiple characters?*](http://stackoverflow.com/questions/1671040/can-mysql-replace-multiple-characters) — M Khalid Junaid, Nov 07 '14 at 19:52

score 13 · Accepted Answer · answered Nov 07 '14 at 19:53

If you are replacing multiple character then you need to use multiple replace in one query something as below. But if there are many characters to be replaced then its better to use application layer to handle it. In other words for few replacement its easy to use query but for many character replacement the query really becomes messy and ends up hard to read or change.

select
replace(
  replace(string_column,'/','//'),'&','&&'
)

MySQL REPLACE multiple values

1 Answers1