Home / Questions / 83570
Accepted
J. Mick
Asked: 2020-07-04 20:51:56 +0800 CST 2020-07-04 20:51:56 +0800 CST

How to show the products from the second id onwards?

  • 772

I need to display the products from the second product onwards. To get the idea, I show an example of the database layout.

id     product
1       One
2       Two
3       there
4       Four
5       Five

I need to show the products starting from id -> 2onwards.

I have tried this way, but it only shows me the product of id -> 2and not the rest of the products.

Select * from products where id = 2 and active='1' order by id ASC limit 16
php

3 Answers

  1. If the ID is autoincrement (not generated and numeric) it would suffice to obtain the elements that are greater than or equal to 2 , that is ID >= 2

    Select * from products  where id >= 2 and active='1' order by id ASC limit 16 ;
/* Otra forma sería*/
Select * from products  where id <> 1 and active='1' order by id ASC limit 16 ;
    • 8

  2. First we order the data with order by id ASCand then if we make a query saying that he idhas to be greater than and equal to 2 ( >=2) being like this

    select * from products where id >= 2 order by id ASC
    • 4
  3. Best Answer

    The clause LIMITcan be used to restrict the number of records that are returned in a query SELECT. Receive one or two arguments.

    If we use LIMIT with a single argument, we will be selecting only the Nfirst elements of our table.

    // Devuelve los dos primeros registros
SELECT * FROM tabla LIMIT 2

    By default, the initial record is 0, that is, it is 0equivalent to the first record of the table.

    If we use LIMIT with two arguments, the first argument specifies the first record to return and the second the total number of records to return.

    // Devuelve 10 registros de la tabla, empezando por el tercero e ignorando los dos primeros
SELECT * FROM tabla LIMIT 2,10

    LIMITIf we use a large enough number as the second parameter, it will select all the records of a table.

    SELECT * FROM tabla WHERE LIMIT 1, 18446744073709551615

    * The use of LIMITin conjunction with the statement is recommended ORDER BYto avoid inconsistent results.

    It seems to me that the best solution in this case is the following query because it returns all the products that are active, from the second to the last one regardless of the table ID. It is a nuance to take into account, especially if it is allowed to delete records from the table and the first record becomes something other than id 1.

    SELECT * from products WHERE active='1' ORDER BY id ASC LIMIT 1, 18446744073709551615;
    • 3