MYSQL cleaning text string keeping alpha characters and white space

Wednesday, November 4, 2015

I am trying to write a function that cleans a text string in MySQL. It works fine but I can't get REGEXP to leave white space in. The current statement is



IF c  REGEXP '[A-Za-z]' THEN 


obviously this is going to take out anything thats not an alpha character but how do I add white space into the list?

0 comments:

Post a Comment