如何使用trim（）并更新mysql中的所有行[复制]

Question

This question already has an answer here:

• MySQL remove all whitespaces from the entire column 5 answers

I have a big table in mysql. Around the string in my record is waste space, something like this:

+---------------------------+----------------------------+
|        anything           |           anything         |
----------------------------------------------------------
|        anything           |           anything         |
+---------------------------+----------------------------+

Now i want this:

+--------+--------+
|anything|anything|
-------------------
|anything|anything|
+--------+--------+

In fact i want to use trim() for all rows and update them. how can i do that ?

</div>

Answer 1

As noted in several the comments:

UPDATE sometable SET column1 = TRIM(column1), column2 = TRIM(column2);