Re: [AMaViS-user] How to identify SPAM and SPAMMY mail in SQL

2009-08-03 Thread Thomas Gelf
Spam = S, spammy = s Please note that MySQL is case insensitive on many string comparsion functions with certain encodings. Therefore if using VARCHAR or CHAR s == S could be true for your system. Either change your columns to VARBINARY or BINARY - or use the BINARY() function when comparing

[AMaViS-user] How to identify SPAM and SPAMMY mail in SQL

2009-08-02 Thread Luis Daniel Lucio Quiroz
Hi all, Having SQL schema, in what field and what values I can identify if an email was SPAM and SPAMMY. I'm pretty sure that SPAM is in msgs.content = S, but spammy? TIA LD -- Let Crystal Reports handle the reporting