vendredi 10 avril 2015

Line Breaks in MySQL Column

I have a mySQL column called description and I have several sentences in this column. For example: "John ran down a hill. He was tired. John went to get water." I would like a line break after each sentence so that it outputs like:


John went to get water.

He was tired.

John went to get water.


I'm using a SQLite DB Browser (http://ift.tt/1onWUjW). I thought I could do line breaks with: "John ran down a hill. \n" but unfortunately it outputs the \n as well as the "". Can anyone help me with these line breaks? Thanks!


Aucun commentaire:

Enregistrer un commentaire