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