Category Archives: MySQL

Mysql – Remove firts/last characters from a string

Remove firts or last characters from a string: UPDATE `table` SET `column` =  TRIM(leading  ‘1c3’  FROM `column`); #first characters (1c3) UPDATE `table` SET `column` =  TRIM(trailing  ‘xyz’  FROM `column`); #last characters (xyz)

Posted in MySQL | Leave a comment