[MySQL] Removing Carriage Returns and Line Feeds from Fields

1
update table set item=replace(replace(item, char(10), ''), char(13), '') where condition;

table: table name
item: field name
condition: query condition