A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns...
Source: Stack Overflow - How to Remove Tabs
- UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`));