A user on my forum has intentionally replaced all their posts with links to dangerous websites, gore or simply dots.
Is there an SQL query I can run to delete posts containing certain links or words? I don't want to remove all of his posts because A.) some of them don't contain spam and are constructive to the topic and B.) I don't want to give in to such behaviour.
I've never done an SQL query before so step-by-step instructions would be much appreciated.
Last edited by Mick
on Tue Sep 20, 2022 11:07 am, edited 1 time in total.