Mysql update query to remove spaces
TRIM() function is used in mysql to remove spaces from the values.
Example
UPDATE employees SET center_id = TRIM(center_id) WHERE center_id LIKE "%103"
TRIM() function is used in mysql to remove spaces from the values.
UPDATE employees SET center_id = TRIM(center_id) WHERE center_id LIKE "%103"
February 28, 2013
May 17, 2015
December 30, 2014