MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: extra line and carraiage return \r\n\r\n added to data
Posted by: Ramalingam Chelliah
Date: September 13, 2004 01:15AM

Hi,
Try using TRIM( ) function....

Refer:

http://dev.mysql.com/doc/mysql/en/String_functions.html


mysql> SELECT
TRIM( TRAILING '\r\n' FROM 'hello\r\n\r\n\r\n') as Result ;

+--------+
| Result |
+--------+
| hello |
+--------+
1 row in set (0.00 sec)

Hope this helps ....

Regards,
Ram.


We Learn the Most When we have to Invent

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
extra line and carraiage return \r\n\r\n added to data
darren l
September 12, 2004 06:08PM
Re: extra line and carraiage return \r\n\r\n added to data
Ramalingam Chelliah
September 13, 2004 01:15AM
Re: extra line and carraiage return \r\n\r\n added to data
darren l
September 13, 2004 03:31PM
Re: extra line and carraiage return \r\n\r\n added to data
Ramalingam Chelliah
September 13, 2004 09:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.