[anarchoi]

just one stupid question : how can i select only the SECOND entry of a table?

with LIMIT, 2 it would display the first and the second

[UnrealEd]

SELECT * FROM mytable LIMIT 1, 2 

You just have to define the offset: 0 means "beginning of the table", and 1 means starting from the second row. It goes on for 3,4,5,...

[anarchoi]

this display the first AND the second entry unless i'm doing something wrong

i want just the second entry

[UnrealEd]

this should display the second and third row. If you just replace the 2 by 1, it will display the second row:

SELECT * FROM mytable LIMIT 1, 1 

i tested it on my server when i posted the code in my previous code, and it worked just fine. Anyway, you should be able to fix it yourself:
the first number defines the offset of the query
the last number defines the length of the returned result

more information: http://dev.mysql.com/doc/refman/5.0/...html#id3093998

[Sxooter]

Note that most later version of mysql allow the limit / offet syntax, which is much more clear.

select * from sometable order by somefield limit 1 offset 1

(offset 0 would get you the first row)

pgsql dropped support for the limit x,y syntax some time ago because theirs was limit,offset while mysql was offset,limit and it lead to a lot of confusion. both dbs support offset x limit y syntax, so I tend to use that more often because it's both more readable and portable.