Articles > Development
I Recently needed to remove carriage returns and line feeds from a MySQL Database. Here is the commands that you need:
UPDATE TableNAme SET ColName = REPLACE(ColName,'\n','')
UPDATE TableNAme SET ColName = REPLACE(ColName,'\r','')
Remove CR LF in MySQL
Last Updated: 9/13/08I Recently needed to remove carriage returns and line feeds from a MySQL Database. Here is the commands that you need:
UPDATE TableNAme SET ColName = REPLACE(ColName,'\n','')
UPDATE TableNAme SET ColName = REPLACE(ColName,'\r','')
Keywords: SQL MySql database remove carriage return line feed trim command not working