How to remove new line characters from data rows in mysql?

by 
UPDATE test SET log = REPLACE(REPLACE(log, '\r', ''), '\n', '');

worked for me.

while its similar, it’ll also get rid of \r\n

http://lists.mysql.com/mysql/182689

More Related Contents:

  1. SQL split values to multiple rows
  2. How do I escape reserved words used as column names? MySQL/Create Table
  3. How to populate a table with a range of dates?
  4. What is the opposite of GROUP_CONCAT in MySQL?
  5. How to Perform an UPSERT so that I can use both new and old values in update part
  6. brew install mysql on macOS
  7. MySQL: selecting rows where a column is null
  8. How do I check to see if a value is an integer in MySQL?
  9. Convert timestamp to date in MySQL query
  10. Update a column value, replacing part of a string
  11. MySQL error 1064 syntax but everything seems fine
  12. MySQL/MariaDB – order by inside subquery
  13. How to run SQL script in MySQL?
  14. Sort by order of values in a select statement “in” clause in mysql
  15. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  16. Removing MySQL 5.7 Completely [closed]
  17. How to optimize COUNT(*) performance on InnoDB by using index
  18. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  19. MySQL Stored Procedures not working with SELECT (basic question)
  20. ERROR 1148: The used command is not allowed with this MySQL version
  21. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  22. Too many auto increments with ON DUPLICATE KEY UPDATE
  23. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  24. Select by Month of a field
  25. MySQL Illegal mix of collations
  26. MySQL GROUP BY age range including null ranges
  27. MySQL update statement to store ranking positions
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment