How to replace more than one keyword in a string in MYSQL using REPLACE and regex [duplicate]

Question

I have sets of field values in mysql table like

aaaworld
worldme
make
pull
pullme
aaatag
tagbbb
aaamousebbb

Now I want to remove every occurance of aaa and bbb and replace the same with "", I tried with below expression

SELECT REPLACE(keywordSupplied,"aaa|bbb","") FROM table1

here it is replacing only the aaa part with "" while bbb part remains as it is. How can I replace occurances of both

adarsh hota · Accepted Answer · 2015-01-06 07:46:59Z

0

You can use "||" instead of "|".It might work.

answered Jan 6, 2015 at 7:46

adarsh hota

32711 silver badges23 bronze badges

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

1 Answer 1