Print Page | Close Window

MySQL keyword Query

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4563
Printed Date: 02 June 2025 at 9:06pm


Topic: MySQL keyword Query
Posted By: keizersozay
Subject: MySQL keyword Query
Date Posted: 15 November 2004 at 9:24am

Does anyone know of a query that I can run in MySql to see which keywords are blocking emails, and how many? I’d like to find out which RegEx strings are working..

 

Thanks.


Replies:
Posted By: Guests
Date Posted: 15 November 2004 at 1:49pm

This should set you on the right track:

SELECT rejectdetails, COUNT(*) FROM tblquarantine where ((rejectid=13) AND (deliver = 0) and (expire = 0)) GROUP BY rejectdetails;

-Ric

Posted By: keizersozay
Date Posted: 15 November 2004 at 1:53pm
Thanks, that is perfect.


Print Page | Close Window