Trimming in MySQL



In MySQL this is quite easy:

select trim(both '\n' from FIELDNAME) from TABLE;

So if your table is "stuff" and the field is "descriptio n" you would say:

select trim(both '\n' from description) from stuff;

I'm searching for an easy way to trim all whitespace (spaces, tabs, and newlines) from strings in MySQL. No luck so...