I need to select everything from table except first record. Because I'm displaying first record differently in HTML. I tried LIMIT -1, but I found LIMIT cannot be negative.
EDIT: I can't use order by because I'm ordering it already by date.
Asked
Active
Viewed 14 times
0
-
which db you are using ???' – scaisEdge Mar 01 '19 at 19:30
-
Before anyone says that is not a duplicate: there are a lot of duplicates for this question. The OP should search the site before posting a question like this. – Jay Blanchard Mar 01 '19 at 19:32
-
I'm using MySQL – hazard Mar 01 '19 at 19:32
-
https://stackoverflow.com/questions/7098202/mysql-get-all-results-but-first – Jay Blanchard Mar 01 '19 at 19:33
-
Also don't forget there is no "first" record unless you use `ORDER BY` in combination with `LIMIT` in MySQL.. SQL tables/results are **orderless** by definition – Raymond Nijland Mar 01 '19 at 19:54