mysql select first/last

[shadowayex]

I was wondering if there was a mysql function that I could use to pull out the first or last row in a table. If not, I can write a little script to do it myself, but I figured I'd see about if there was a premade function to do it first.

[zppblood]

MIN() and MAX().

[jhecht]

select * from table ORDER BY id_column DESC limit 1 //For the maximumSELECT * FROM table ORDER BY id_column ASC LIMIT 1 //for the minimum

[shadowayex]

select * from table ORDER BY id_column DESC limit 1 //For the maximumSELECT * FROM table ORDER BY id_column ASC LIMIT 1 //for the minimum

Works, thanks.