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"
Share

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *