Setup a scheduled task / cron to remove x text in posts + task to prune posts with x

[John Diver]

Hey,

I am manually having to search for posts that have advertising in my forum but the posts are good posts and I would like to keep the post.

For example if the post had a link to a gambling site (My site has a section related to gambling - checked and verified by the adsense support ) and people are linking to site, but I am using adsense so I have to ensure no links are posted.

Is there a way to search for posts with a link?

The second question is about removing posts via pruning if the title has the words x in the title - I know this is already an option in the admin panel but it takes a lot of time trying to do them all manually, if I could setup a cron or scheduled task in the admincp that would save me so much time

Thanks for reading!