XF 2.0 Search image link

[GKBlaze]

Can someone write me the query where I can search for a specific image link that appear in all threads?

Thanks for your help.

 

[AndyB]

You might like this add-on:

https://xenforo.com/community/resources/advanced-search.5602/

 

[GKBlaze]

You might like this add-on:

https://xenforo.com/community/resources/advanced-search.5602/

I just need to search for one single image so a query will do the job. Thanks for the recommendation though.

 

[GKBlaze]

For those that need the query

SELECT * FROM xf_post WHERE message LIKE '%imagelink%'

and if you need to replace the image link or any content with something else.

UPDATE xf_post SET message = REPLACE(message, 'originalcontent', 'replacewiththis') WHERE INSTR(message, 'originalcontent') > 0;