n00b0101
asked on
MySQL - Trim whitespaces & line breaks?
First, is is possible to trim line breaks from fields in my table?
Second, if I use trim, will it remove *all* the whitespace at the end of a field? In some cases, it looks like the data has multiple spaces at the end, and I want to be certain that I won't have to run TRIM repeatedly?
Second, if I use trim, will it remove *all* the whitespace at the end of a field? In some cases, it looks like the data has multiple spaces at the end, and I want to be certain that I won't have to run TRIM repeatedly?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.