[RSS Feed/News] Unable to replace text in SQL database

XenForo · Jan 18, 2023

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

Code:

Code:

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:

Code:

Code:

Fusce fermentum odio nec arcu

Sed in libero ut nibh

I have executed this query:

Code:

Code:

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

Vestibulum suscipit nulla...