MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: MySQL Long Text Field - How to retrieve data with no new line \n
Posted by: Georg Richter
Date: May 28, 2005 11:11AM

Why don't use the REPLACE function when selecting the data?

SELECT REPLACE(yourlongtextfield,'\n', '') FROM yourtable

/Georg

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


Subject
Written By
Posted
MySQL Long Text Field - How to retrieve data with no new line \n
Massimo Amelio
May 27, 2005 05:59AM
Re: MySQL Long Text Field - How to retrieve data with no new line \n
Georg Richter
May 28, 2005 11:11AM


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.