UPDATE table SET field=REPLACE(field, field, TRIM(BOTH '\r\n' FROM field))
---
There are 2 other entries posted on this day.