I want to add a line break in mySQL inline query..
I am trying to execute
update sample set post_text = replace (post_text,'http:/','¶http:/'
) where id =64
here ¶ (ascii code 182) represent the end of paragraph.
My aim is to provide a extra line break infront of 'http:/'
tag in DB field. And i dont know how to insert a line break in a query of MYSQL