Query BD and show all results except the first

Question

I have the table tbl_galeria, what happens is that I want to make a consultation, but the consultation cannot show the first result. That is, the query will return all values except the one with the smallest id.

$query = mysql_query("SELECT * FROM tbl_galeira ORDER BY id ASC");

Answer 1

You can do with the MIN mysql:

$query = mysql_query("SELECT * FROM tbl_galeira WHERE id > (SELECT MIN(id) FROM tbl_galeira) ORDER BY id ASC");

Answer 2

Simple and direct solution without subquery:

$query = mysql_query( 'SELECT * FROM tbl_galeira ORDER BY id LIMIT 1,999999999' ).

The second parameter of LIMIT is absurdly larger than its intended application. Remember that 0 is the first record, so we use 1 to catch from the second on.

_{Syntax may seem strange, but it’s more effective than engine compare Ids line by line (plus more readable).}

Answer 3

You can do a sub-discharge:

SELECT * 
FROM tbl_galeira, 
    (SELECT id as fId FROM tbl_galeira ORDER BY id ASC limit 1) f 
WHERE id > f.fId

Answer 4

It is interesting to know how many records you want to return. Let’s say 10, you would do the following:

$query = mysql_query("SELECT * FROM tbl_galeira ORDER BY id ASC LIMIT 10, 1");