does limit 3,1 load the entire table into memory?

[james438]

does the following
select * from tablename where summary LIKE '%term%' order by ID desc limit 9, 3 load the entire table into memory?

[james438]

I am going to guess that it does not load the entier database into memory.