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 values.
If running a large DB you should definitively change column types, as using string functions in your WHERE statements is seldom a good idea (performance-wise). Best regards, Thomas Gelf Luis Daniel Lucio Quiroz wrote: > 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 - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > AMaViS-user mailing list > AMaViS-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/amavis-user > AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 > AMaViS-HowTos:http://www.amavis.org/howto/ > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/