Way to get rid of ending spaces in SQL?
 

I have a mySQL database I am working with that came from an Excel spreadsheet (export to CSV, import with phpMyAdmin). However, when this was done, most of the fields have long strings of spaces at the end of them. Is there any way to get rid of this? Im working with PHP--if someone could suggest a quick PHP script that would run through and chomp the spaces off the end of every cell, Id be most thankful.

what you are looking for is either trim, ltrim or rtrim

Look those up in the PHP manual, and you can figure out exactly what you want to do with them.

But you are basically going to have to do a bunch of database reads, and then a bunch of updates. So, no easy way I know of to do this automatically in phpMyAdmin.

Awesome, thats exactly what I was looking for. I just wrote a quick script to go through everything and run it through the rtrim() function. Thanks!

for future reference, the trim() function strips them from both sides at the same time.

Thanks. I saw that listed with rtrim() but the spaces came from the CSV file and were all on the right side of the string. I guess I probably should have done trim() anyways--not gonna hurt and woulda made sure...