How to remove spaces in a column at the beginning of each value?

Question

MySQL

I have a database with a product table and a producte_code column . Is it possible to make an SQL query to remove spaces at the beginning of each value in the product_code column ?
Some products in the online store, when filling out, content managers wrote down with a space at the beginning of the product name. I would like to fix everything with one request.

Answer 1

update product t 
set t.product_code = trim(t.product_code) 
where t.product_code != trim(t.product_code);

It is possible without the where clause. You need to watch if something breaks (for example, some consumers look at the date of the last row update).