Lesser of two values in list

I need to find the lesser of two values provided in a list. I know I can do=
it with a couple of IF's in a function, but I'd really like to know if the=
re is already a function that I can use.

min(12,3,1,4) of course doesnt work, but is there some other math function=
I am overlooking in MySql?=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Lesser of two values in list

--------------040001090504090004080402
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

>I need to find the lesser of two values provided in a list

LEAST().

PB
http://www.artfulsoftware.com

-----

Cantwell, Bryan wrote:
> I need to find the lesser of two values provided in a list. I know I can do it with a couple of IF's in a function, but I'd really like to know if there is already a function that I can use.
>
> min(12,3,1,4) of course doesnt work, but is there some other math function I am overlooking in MySql?
>
> ------------------------------------------------------------ ------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.427 / Virus Database: 270.14.111/2570 - Release Date: 12/17/09 08:30:00
>
>

--------------040001090504090004080402--