--- In [email protected], James Keeline <[EMAIL PROTECTED]> wrote: > > > --- whoisquilty <[EMAIL PROTECTED]> wrote: > > > I've got a MySQL query that sorts by a column and limits the results to only > > display the first > > result. > > > > I'd like another query where it sorts by the same column and displays the > > next three rows in > > the table. So, it would need to omit the first row and show rows 2 - 4. > > > > How do I do this? > > Try to use this LIMIT clause in your query: > > LIMIT 2, 3 > > or > > LIMIT 1, 3 > > I can't recall off the top of my head which one works best. I recall > describing it to my students as how many rows to skip followed by how many to > show. This suggests the second version is right. > > James >
LIMIT 1,3 worked. The first number skips that number of rows, the second number displays that number of rows. THANK YOU!!!!!!!!!!
