Select JUST the latest post from MYSQL

[jung]

How does one specify (in a select statement) the return of the highest number in a field? or say the LAST record submitted?

Yes, I can select all, reverse sort by record id and LIMIT 1 BUT that seems like the long way.

---

Thanks in Advance,

Fritz Jung
Co-Founder - The Witches' Voice
http://www.witchvox.com

[Drakla]

select MAX(field) from sometable;