mysql trim

BEGIN;

update api_tao_category c1, api_tao_category c2 set c1.category_img = TRIM(LEADING ' ' FROM c2.category_img) where  c1.id = c2.id  ;

COMMIT;

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)