When i copy a text and upload it the output looks like that
PROLOGUE\n\n\nIF you leave the city by the Porta Maggiore and take the Via\nPrænestina, which leads east into the Sabine hills, at some thirty-six\nkilometers
i want to replace \n with a line break
i use this
`UPDATE messages SET `text` = REPLACE( `text` , '\r' OR '\n' OR '\r\n') `
The **n** goes but the **\** stays
Any help?