On Mon, Aug 12, 2002 at 12:55:32PM -0400, 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 condit
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, Sh
