LIMIT clause would affect row count?

[Atealtha]

Would a num_rows function return just the # actually returned by the LIMIT clause or would it return the # that is covered under a WHERE clause?

[JRMillion]

num rows tells you how many rows were returned by the query....
LIMIT is part of the query and limits how many rows are returned.

[r937]

have a look at the FOUND_ROWS() function in 12.8.3 Information Functions

[stymiee]

I always learn something from your posts, Rudy.