Just a minor correction...
select YourField from YourTable order by YourField DESC limit 1;
('DESC' in order to return the greatest value first)
On Tue, 11 May 2004 17:28:05 +0200, Mikhail Entaltsev
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> select YourField from YourTable order by YourField limit 1;
>
> Best regards,
> Mikhail.
>
>
> ----- Original Message -----
> From: "A Z" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, May 11, 2004 3:01 PM
> Subject: Max
>
> >
> > Hi,
> >
> > A field of type VarChar() with following syntax:
> > ABA1.
> > How to get the Max value. Bearing in mind that value
> > ABA10 comes before ABA2.
> >
> > regards
> >
> >
> >
> >
> >
> >
> > ____________________________________________________________
> > Yahoo! Messenger - Communicate instantly..."Ping"
> > your friends today! Download Messenger Now
> > http://uk.messenger.yahoo.com/download/index.html
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
