MySQL - Trim carriage returns (or any characters)

In the following formula '\n' represents a carriage return. You may also want to use '\r' or a combination of both, depending on the type of carriage return (unix/windows).

trim( BOTH '\n' from `FIELD_NAME` )