MySQL - Preg Replace

Question

I have 2 column in table: C1, C2

I want to update

C2 = Replace(C1, everything not a-zA-Z0-9\s(space), "")

but I can't find out how to do it :(

Answer 1

Please see this question: How to do a regular expression replace in MySQL?

You can use regex in MySQL