if you are using this while going through an API like perl,php,c,c++ then you could do a call like "select LogID from Log WHERE LogIP="10.0.0.22" ORDER BY LogID DESC LIMIT 100" and run mysql_num_rows() on the resultant mysql query object. hope this is at least somewhat helpful.
Cummings, Shawn (GNAPs) wrote: > > If I have 4,000,000 records, and I just want to make sure that the > last 100 records do not contain a certain value, ... how can I > efficiently 'count' the number of times in the LAST 100 records that a > specific condition exists? > > As an example, > > mysql> select COUNT(*) from Log WHERE LogIP="10.0.0.22" ORDER BY LogID > LIMIT 100; > > The above syntax actually COUNTs all the occurances, not just the > COUNT from the last 10 records... > > My goal is to check for specific conditions on ONLY the last couple > records, so that the entire table does not have to be reviewed. > > Any thoughts, ideas or comments? > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
