MySQL update to remove whitespaces
Posted by Cătălin on Wed, 13 Sep 2017
This is how you can replace spaces with MySQL update query
Replace spaces
UPDATE `table` SET `col_name` = REPLACE(`col_name`, ' ', '')Remove all tabs characters
UPDATE `table` SET `col_name` = REPLACE(`col_name`, '\t', '' )Remove all new line characters
UPDATE `table` SET `col_name` = REPLACE(`col_name`, '\n', '')Remove first and last space(s) of column
UPDATE `table` SET `col_name` = TRIM(`col_name`)
Archives
- May 2023 1
- April 2023 1
- March 2023 3
- January 2020 1
- November 2019 1
- September 2019 1
- April 2018 2
- February 2018 1
- January 2018 3
- December 2017 2
- November 2017 2
- October 2017 2
- September 2017 1
- July 2017 2
- June 2017 2
- May 2017 1
- March 2017 2
- February 2017 2
- January 2017 2
- November 2016 1
- October 2016 4
- August 2016 1
- April 2016 1
- June 2015 1
- May 2015 2
- April 2015 1
- December 2014 1
- October 2014 2
- September 2014 1
- July 2014 2
- June 2014 1
- March 2014 1
- February 2014 2
- January 2014 2
- December 2013 2
- October 2013 2
- September 2013 2
- July 2013 2
- June 2013 1
- March 2013 1
- February 2013 3
- January 2013 1
- December 2012 1
- November 2012 1
- September 2012 1
- August 2012 2
- April 2012 1
- August 2011 2
- July 2011 2
- January 2011 1
- October 2010 5
- August 2010 2
- July 2010 3
- May 2010 1
- April 2010 5
- March 2010 3
- February 2010 2