Jump to content

Replace script for string in table ipb_forums_posts -> post


Recommended Posts


I was moving to IPS in 2014. In the old forums software, there a few strings, that I have to delete.

table ipb_forums_posts -> post

One of these strings (with different characters in some positions) is:


In the above example 47985 and 925506 is variable.

In all posts the complete string with the different variables has to be replaces with nothing.

Directly in MySQL it is not possible, because REPLACE() does not have any support for wildcards, patterns, regular expressions.

The other string is:

<a href="http://www.polar-chat.de/topic.php?id=80490&amp;goto=1783330" rel="external">Originalbeitrag</a><p>

In this example 80490 and 1783330 is variable.

So there are 30.000 and more of these string, that should be replaces with nothing.

I mean the complete string no matter what different numbers appear in it. 

Of course I would pay for a quick and dirty script, that could do that.

I really need this ...

Thanks in advance.


Link to comment


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...