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.

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
– Mannie Singh, Commented Jun 10, 2013 at 20:47

phadaphunk · Accepted Answer · 2013-06-10 20:53:48Z

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, 2013 at 20:53

phadaphunk

13.4k17 gold badges77 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sorry I want to keep one space not remove all.