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

Discussion in 'MySQL' started by asifakhtar, Jan 15, 2023.

0
  1. #1
    How can I remove all occurrence of , and I from a string using REGEXP_REPLACE? Tried the following but it doesn't work

    regexp_replace('123,|4abcd, aaa|,qqq|a', '|,', '', 'g')
     
    asifakhtar, Jan 15, 2023 IP