In mysql, the db will continue reading even if the limit condition has been met, and then anything beyond the limit will be discarded before returning the result.