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