Spam Filter ISP Forums : MySql Statistical filter match query https://www.logsat.com/spamfilter/forums/ Fri, 17 Apr 2026 02:45:22 +0000 Mon, 15 Nov 2004 13:55:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=4565 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[MySql Statistical filter match query : SELECT tblMsgs.MsgId, tblMsgs.MsgFROM...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4565&PID=4568&title=mysql-statistical-filter-match-query#4568 Author: keizersozay
Subject: 4565
Posted: 15 November 2004 at 1:55pm

SELECT     tblMsgs.MsgId, tblMsgs.Msg
FROM         tblQuarantine INNER JOIN
                      tblMsgs ON tblQuarantine.MsgID = tblMsgs.MsgID and tblQuarantine.RejectID = 14
GROUP BY tblMsgs.MsgID;

 

This seems to be working for me.
I use the mysql control center to run the queries so that they are easier to read.

]]> Mon, 15 Nov 2004 13:55:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4565&PID=4568&title=mysql-statistical-filter-match-query#4568 <![CDATA[MySql Statistical filter match query : Is there an easy way to see which...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4565&PID=4565&title=mysql-statistical-filter-match-query#4565 Author: keizersozay
Subject: 4565
Posted: 15 November 2004 at 12:13pm

Is there an easy way to see which messages are blocked by the Bayes filter? Using the quarantine viewer in spamfilter is tedious and I can’t seem to find anything with a reject id of 14, which I believe is the id for the bayes filter... (when I run the other MySql query posted by Roberto it says that I do have some messages rejected by the statistical filter match.)

 

Anyone know of a mysql query?

]]> Mon, 15 Nov 2004 12:13:00 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4565&PID=4565&title=mysql-statistical-filter-match-query#4565