XF 2.1 Database select

[vFranky]

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]

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]

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.