Hi I am new to Mysql and Regexp and wanted help in running the below regexp to clear whitespaces from a column called description in my table.
string = string.replace(/\s{2,}/g, ' ');
Can someone please help? I can do basic query's.
Asked
Active
Viewed 38 times
0
-
Do you **absolutely** want to use regex ? – phadaphunk Jun 10 '13 at 20:42
-
http://stackoverflow.com/questions/986826/how-to-do-a-regular-expression-replace-in-mysql – Jess Kenney Jun 10 '13 at 20:43
-
No i am open to suggestions i want to remove all white spaces apart from one whitespace thats why i though Regexp was best. – Mannie Singh Jun 10 '13 at 20:47
1 Answers
2
No need for RegEx in that case.
You can simply use the Trim() function from mySQL.
It will simply remove all the white spaces :
SELECT TRIM(' removeSpaces ');
--------
OUTPUT : [removeSpaces]
phadaphunk
- 12,785
- 15
- 73
- 107