How can I remove all occurrences of $ and , from a string using REGEXP_REPLACE in mysql-10.4.24-MariaDB?

[asifakhtar]

I tried the following but it doesn’t work.
REGEXP_REPLACE(‘$25,000.00’,‘$|,’,“”)
REGEXP_REPLACE(‘$25,000.00’,‘$’,“”)
REGEXP_REPLACE(‘$25,000.00’,‘[$,]’,“”)

[Thallius]

$ is a special char you need to escape

REGEXP_REPLACE(‘$25,000.00’,‘[\$,]’,“”)

Should do the trick

[asifakhtar]

@Thallius

REGEXP_REPLACE(‘$25,000.00’,‘[\$,]’,“”)

Tried and it doesn’t work.

[Thallius]

@Thallius

SELECT REGEXP_REPLACE(‘$25,000.00’,‘[\$,]’,‘’)

Works absolutely fine

DB Fiddle - SQL Database Playground

[r937]

@asifakhtar

Tried and it doesn’t work.

that’s because you forgot to replace @Thallius’s microsoft curly quotes with good old fashioned normal quotes

[Thallius]

@r937

that’s because you forgot to replace @Thallius’s microsoft curly quotes with good old fashioned normal quotes

I guess that doesn’t matter as he will find an answer on one of the 8 other forums he has posted the same question the same time…