visitor image search query

[GKPet]

Can someone write me a query that runs a search in all visitor message for a specific image url link??

[kh99]

Try this:

SELECT * FROM `visitormessage` WHERE pagetext LIKE '%http://www.mysite.com/image.gif%'

[GKPet]

Thanks that worked :)