Remove all spaces from the entire column in mysql

Name: Redmi Y2 Tech Review
Uploaded: 2018-08-05 T20:00:00+05:30
Duration: 6 min 59 s
Description: Namasty dosto is video maine Xiaom Redmi Y2 bare mein baat krunga, or sath hi Redmi Y2 ke kuch key features aapke sath share krunga. 1. Dual 12MP + 5MP cameras width Precise bokeh effect. 2. 16MP front camera width 4500K soft-toned light.

Is there a way to remove all whitespaces from a specific column for all values?

Deepak Sharma

Asked 13-11-2024

143

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