mysql: limit 0,10?

Question

if you limit an sql select query,...eg.. limit 0,100 does that mean that in this example it stops searching the database when it has found 100 results, or does it search the whole table but only select 100 results? thanks to any responders.

Answer 1

This limit statement is setting a range of records to display, so the first number represents the first record, and the second is the last... "show records 1 through 100".