Searching posts for a literal string?

[probeman]

I need to search all my forum posts for a literal string. This string (":80"), will be in some embedded image links in some of the posts.

Is there a way to search for a literal string in all forum posts?

[vbgamer45]

Do you need to do this though the forum search?  What is the reason for the search?
If not you can do a search in the database in the smf_messages table to get a list of posts.

[probeman]

Hi,
Thanks.

It's because some old image links utilized port 80 and they no longer work now that the web site is https.

Yes, I'd prefer to do it through the normal forum search if possible.

[vbgamer45]

Lastly do you just need to a do find and replace? Like change one url to another url?

[probeman]

Not particularly.  Just find the posts containing the ":80" strings and edit them by hand would be great.

[Sir Osis of Liver]

You can search the _messages table in your database for the string using phpmyadmin.

[probeman]

Yeah, I appreciate that but I'm not qualified to do that sort of thing.  Is there no way to do it from the forum search (advanced?) web page?
john

[Sir Osis of Liver]

You can use advanced search to search all boards for :80.  It's sufficiently unique that you shouldn't get many bad hits.

[probeman]

OMG it's does do a search inside the link in the post.  Cool. I should have tried it first.