I have a whole heap of spam in a table that I'm trying to get rid of.
What makes the posts the same is the following text:
However when I search for it with the below query I get 0 results back which I assume is because of those % wildcard characters. How can I get around this to show all comments with the above text within them? Please ignore the /url tag because EE is asking me to put that in.
WHERE COMMENT LIKE '
and ApprovalStatus = 0