Mysql - Mysql remove new line using select, Mysql cut or trim new line select query

Mysql remove new line using select

 # SELECT TRIM(name) AS name FROM your_table

Syntax for trim function

 # TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM ] str)

Trim new line of specified field

 # select * from tablename where TRIM(BOTH '\r' from (TRIM(BOTH '\n' from filedname))) = '$value'

where,
LTRIM() = Removes leading spaces
RTRIM() = Removes trailing spaces
TRIM() = Removes leading and trailing spaces

By using the above query you can remove new line from in mysql database

The topic on Mysql - Mysql remove new line using select is posted by - Math

Hope you have enjoyed, Mysql - Mysql remove new line using selectThanks for your time