How to use the following Regexp to run as a replace/update sql query in Mysql

Question

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.

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

score 2 · Answer 1 · answered Jun 10 '13 at 20:53

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]

answered Jun 10 '13 at 20:53

phadaphunk

Sorry I want to keep one space not remove all. – Mannie Singh Jun 10 '13 at 21:22

1 Answers1