mysql - query to remove multiple characters from column content

Question

Can I create a query using "replace" to remove more than one character\string from a column content ?

For example I have:

UPDATE table1 SET column1 = REPLACE(column1, '\r\n', '');

But what if I want to remove multiple characters or strings like:

<br />
<&nbsp>
<\r>

Is it possible to run this in single query ?

juergen d · Accepted Answer · 2013-09-24 10:25:33Z

2

cascade it

UPDATE table1 
SET column1 = replace(replace(REPLACE(column1, '\r\n', ''), '<br />',''), '<\r>','')

answered Sep 24, 2013 at 10:25

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

1 Answer 1