|
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.
__________________
"Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws."
--Plato
|