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','[$,]',"")

 

[alexcray]

I tried the following but it doesn't work.
REGEXP_REPLACE('$25,000.00','$|,',"")
REGEXP_REPLACE('$25,000.00','\$',"")
REGEXP_REPLACE('$25,000.00','[$,]',"")

To remove all occurrences of $ and , from a string using REGEXP_REPLACE in MySQL, you can use the following query:

sql
Copy code
SELECT REGEXP_REPLACE(your_column, '[$,]', '') AS modified_string FROM your_table;

Replace your_column with the name of the column containing your string, and your_table with the name of your table.

This query will remove all instances of $ and , from the specified column and return the modified string as modified_string.