MySQL regular expression replace?

Question

I know that MySQL does not have a regular expression replace function but I wondered if anyone has written a user defined function that I could use? I know it's not good to just ask for code answers but I am not very skilled in MySQL and was just looking for some help. If there isn't I can accept that.

Thanks

possible duplicate of How to do a regular expression replace in MySQL? — tadman
– tadman, Commented Oct 10, 2011 at 1:19

imm · Accepted Answer · 2011-10-10 01:18:21Z

1

Try this site:

http://www.mysqludf.org/lib_mysqludf_preg/

answered Oct 10, 2011 at 1:18

imm

5,9391 gold badge29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bobbake4 Over a year ago

This sounds great. It requires installing a library to use perl regex but is a valid solution.

imm Over a year ago

Alternatively, see launchpad.net/mysql-udf-regexp , which was recommended in the post noted by @tadman.

HanhNghien · Accepted Answer · 2012-06-25 17:39:16Z

select 
  replace( replace( replace( replace( replace( 
  replace( replace( replace( replace( replace( 
  replace( replace( replace( replace( replace( 
  replace( replace( replace( replace( replace( 
  replace( replace( replace( replace( replace( 
  replace( replace( replace( replace( replace( 
  replace( replace( replace( replace( replace( 
  replace( replace( replace(

'a~b}c{d`e_f^g\\h[i?j=k;l.m-n,o*p(q&r$s"t u|v]x@y>z<:+)\'%#!\r\f\v\naz\t09\b',

  '~', ''), '}', ''), '{', ''), '`', ''), '_', ''),
  '^', ''), '\\', ''), '[', ''), '?', ''), '=', ''),
  ';', ''), '.', ''), '-', ''), ',', ''), '*', ''),
  '(', ''), '&', ''), '$', ''), '"', ''), ' ', ''),
  '|', ''), ']', ''), '@', ''), '>', ''), '<', ''),
  ':', ''), '+', ''), ')', ''), '\'', ''), '%', ''),
  '#', ''), '!', ''), '\r', ''), '\f', ''), '\v', ''),
  '\n', ''), '\t', ''), '\b', '')

Replace

a~b}c{d`e_f^g\h[i?j=k;l.m-n,o*p(q&r$s"t u|v]x@y>z<:+)\'%#!\r\f\v\naz\t09\b

To

abcdeghijklmnopqrstuxyzaz09

MySQL - Regular Expressions & REPLACE

Collectives™ on Stack Overflow

MySQL regular expression replace?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related