How do I refer to capture groups in a MySQL regex?

by

(Old question, but top search result)

For MySQL 8:

SELECT REGEXP_REPLACE('stackoverflow','(.{5})(.*)','$2$1');
-- "overflowstack"

You can create capture groups with (), and you can refer to them using $1, $2, etc.

For MariaDB, capturing is done in REGEXP_REPLACE with \\1, \\2, etc. respectively.

More Related Contents:

  1. How to do a regular expression replace in MySQL?
  2. MySQL Split Comma Separated String Into Temp Table
  3. MySQL strip non-numeric characters to compare
  4. How to extract two consecutive digits from a text field in MySQL?
  5. How to extract the nth word and count word occurrences in a MySQL string?
  6. How to remove all non-alpha numeric characters from a string in MySQL?
  7. How to count words in MySQL / regular expression replacer?
  8. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  9. Does MySQL Regexp support Unicode matching
  10. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  11. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  12. How to regex in a MySQL query
  13. remove all numeric characters from column mysql
  14. mySQL regex in the where clause
  15. i have an error which i dont understand. can you help me? [closed]
  16. mysql error 1364 Field doesn’t have a default values
  17. SQL: What is the default Order By of queries?
  18. How to group by week in MySQL?
  19. Can I use a function for a default value in MySql?
  20. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  21. Mysql order by specific ID values
  22. How do I check if a column is empty or null in MySQL?
  23. MySQL versus PDO [duplicate]
  24. Mysql string split [duplicate]
  25. Increment a database field by 1
  26. Row number per group in mysql
  27. is there a mysql function to decode html entities?
  28. How to get the mysql table columns data type?
  29. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment