How to form a query in the database so that there is a selection of records starting from the X line?

S

suhuxa12017-10-12 17:25:23

MySQL

suhuxa1, 2017-10-12 17:25:23

Good afternoon!
The title is not entirely clear, I will explain:
There are many records in the table. Among them there are records with a certain parameter, for example, type = 1. How can I display all these records starting from a certain record? For example, I have 100 such posts with this parameter. The first 20 on the page have already been displayed. I want to display 80 more, how can I form a query so that the output starts after the 20th record WITH THIS PARAMETER?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Stanislav Pochepko, 2017-10-12
@suhuxa1

offset
Read documentation
https://laravel.com/docs/5.5/queries#ordering-grou...