Remove Leading and Trailing Characters from MySQL Database
Sometimes you want to remove certain characters from your database but can’t use find and replace because you only want to remove the characters at the beginning and end of a table’s column. This is where TRIM() comes in handy. Here’s how to use it. To remove leading character(s): UPDATE `table` set `field` = TRIM( [...]
