Does anyone use this? Supposedly, it will calculate the number of rows that would have been returned if there was no LIMIT clause. It appears in MySQL's documentation. I get various syntax errors when I use it (but the keyword itself appears to be accepted as valid syntax).
Also, curiously enough, SQL_CALC_FOUND_ROWS (a differently named keyword which does the same thing) appears on the list of features to be added to MySQL 4.0. what gives?
