XF 2.2 Add a paragraph line, via phpmyadmin using bbcode

[Miri]

Hi.
With the search and replace function in phpmyadmin, I want to add a paragraph after a specific keyword.

This is a content that is repeated in some posts:

[url="http://wwww.domain.tld"]etiam sollicitudin...[/url] Praesent porttitor, nulla vitae posuere

now I want to immediately after

[/url]

and before

Praesent

insert a tag to wrap, in a new line.
It would be like the equivalent of <p> in html. I don't want a line break [br] but a new paragraph. How can I do?




Thanks
Miri

 

[Miri]

I read this post (I invite you to vote) by @adamgreenough, and I realized that XenForo doesn't use paragraphs but line breaks.
I currently have solved, with twice enter, from the keyboard, inside the SQL formula

UPDATE `xf_post`
  SET `message` = replace (` message`, 'text test', 'text 

test')

Warning, this worked for me, but I don't know if it's the correct procedure.