Remove all spaces from the entire column in mysql

Is there a way to remove all whitespaces from a specific column for all values?
Deepak Sharma
Asked 11-01-2021
30

Answer (1)
hi here is code for this UPDATE `t1` SET `col1` = REPLACE(`col1`, ' ', '')
Ankur Rajput
Asked 09-11-2019
45 Likes
Comments
Write comment

Submit your answer