MySQL 8.0+:
You can use the native REGEXP_REPLACE
function.
Older versions:
You can use a user-defined function (UDF) like mysql-udf-regexp.
More Related Contents:
- MySQL Split Comma Separated String Into Temp Table
- MySQL strip non-numeric characters to compare
- How to extract two consecutive digits from a text field in MySQL?
- How to extract the nth word and count word occurrences in a MySQL string?
- How to remove all non-alpha numeric characters from a string in MySQL?
- How to count words in MySQL / regular expression replacer?
- #1139 – Got error ‘repetition-operator operand invalid’ from regexp
- Does MySQL Regexp support Unicode matching
- How do I refer to capture groups in a MySQL regex?
- MySQL SELECT LIKE or REGEXP to match multiple words in one record
- Is it Possible to Enforce Data Checking in MySQL using Regular expression
- How to regex in a MySQL query
- remove all numeric characters from column mysql
- mySQL regex in the where clause
- mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
- How to group by two rows in a column
- How to make MySQL table primary key auto increment with some prefix
- How to make MySQL handle UTF-8 properly
- Generate an integer sequence in MySQL
- What column type/length should I use for storing a Bcrypt hashed password in a Database?
- How to conduct an Accent Sensitive search in MySql
- How to import an excel file in to a MySQL database
- How to shrink/purge ibdata1 file in MySQL
- The total number of locks exceeds the lock table size
- How to subtract hours from a datetime in MySQL?
- MySQL sum elements of a column
- Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
- MySQL cumulative sum grouped by date
- Strip last two characters of a column in MySQL
- mysql double-quoted table names