MySQL query

[IFR]

Hi

I'm looking for a query that select the last record of a table(therefor the last unique id)

thank you

[Truti]

SELECT blahblah1 FROM blahblah2 ORDER BY blahblah1 DESC

*DESC stands for decrease... if you want the other way around simply don't use the DESC

enjoy!

[GreyBoy]

I would use:

SELECT * FROM table ORDER BY id LIMIT 0,1

Now Im not really sure if that would work because Ive never tried it.

[seby]

you would need:

SELECT * FROM table ORDER BY id DESC limit 1

[GreyBoy]

OOPs I missed the DESC