MySQL Forums
Forum List  »  PHP

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

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL Long Text Field - How to retrieve data with no new line \n
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.