Q:

Get the minimum value from a list

I want to get the minimum of a list of numbers in MYSQL

select min(1,9,20,..);

is this possible?

A:

The function you are looking for is called LEAST():
select least(2,4,6,8,1,2,3,4) as result;
+--------+
| result |
+--------+
|      1 |
+--------+

