Unable to replace text in SQL database

[Miri]

Hi, I have identical text on some posts for a specific description. The text is as follows:

Sed consequat leo eget bibendum

Vestibulum suscipit nulla quis orci

[B][U]Quisque libero metus condimentum nec![/U][/B]

I would like to replace it with the new text that has only one line break:

Fusce fermentum odio nec arcu

Sed in libero ut nibh

I have executed this query:

UPDATE xf_post SET message = replace(message, 'Sed consequat leo eget bibendum

Vestibulum suscipit nulla quis orci

[B][U]Quisque libero metus condimentum nec![/U][/B]', 'Fusce fermentum odio nec arcu

Sed in libero ut nibh')

I simulated it and it says it's okay, with the number of tables that would be updated. When I click replace, the window says 0 rows modified, without showing any error. In short, I can't replace the text.

I have also tried adding \n I have also installed this official XenForo module and still was not able to.

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

Can anyone please explain to me how to replace the text? I am working on a copy.

 

[Miri]

I have solved it.
I was missing some \n I must have confused the new line with the line break.