Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - MySQL keyword Query
  FAQ FAQ  Forum Search   Register Register  Login Login

MySQL keyword Query

 Post Reply Post Reply
Author
keizersozay View Drop Down
Groupie
Groupie
Avatar

Joined: 26 January 2005
Location: United States
Status: Offline
Points: 77
Post Options Post Options   Thanks (0) Thanks(0)   Quote keizersozay Quote  Post ReplyReply Direct Link To This Post Topic: MySQL keyword Query
    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.

Back to Top
Ric Marques View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Ric Marques Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
keizersozay View Drop Down
Groupie
Groupie
Avatar

Joined: 26 January 2005
Location: United States
Status: Offline
Points: 77
Post Options Post Options   Thanks (0) Thanks(0)   Quote keizersozay Quote  Post ReplyReply Direct Link To This Post Posted: 15 November 2004 at 1:53pm
Thanks, that is perfect.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.455 seconds.