XF 2.1 Database select

vFranky

Active member
Hello,

I like to use SQL to select (find) all postings in the forum, in which the string "[table" occurs. The result should produce a table with the cols threadname and URL.
Can anyone help to create the necessary SQL statement? Thank you in advance!

Kind regards,
Frank
 

Chris D

XenForo developer
Staff member
What are you trying to do, exactly?

We have an add-on called Post content find and replace which may be useful here, especially if you're wanting to make changes to existing post content.
 

vFranky

Active member
What are you trying to do, exactly?

I like to have a list with threadname (col 1) and url (col 2) of all threads, where the searched string occurs. I do not want to "replace" anything in this case. I already used the add-on "find and replace". We have to convert old tables semi-manually.
 
Top