Trim values along with the tab

: Joel Lipman; MySQL; 13 June 2016; Hits: 3007

What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.

Why?
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...

How?

UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`));

Source: Stack Overflow - How to Remove Tabs

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Strip HTML in MySQL (11793) Joel Lipman (MySQL)
Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit...
Trim values along with the tab (3007) Joel Lipman (MySQL)
What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel...
Generate Academic Calendar using MySQL (7030) Joel Lipman (MySQL)
What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week...
MySQL: Count occurrences of words in a column (7586) Joel Lipman (MySQL)
What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this...
MySQL last year week month day trend periods (10963) Joel Lipman (MySQL)
Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts...
Country Lookup by IP address CSV (8635) Joel Lipman (MySQL)
What? So this is an article to serve as documentation for one of the data sources available to download for FREE from...
MySQL Transactions in PHP (4403) Ike Francis (MySQL)
Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our...