How to search min value from four other different fields in mysql query?

Question

I want to search min value from four fields in mysql query, I have tried a lot of ways but didn't get it, right now I am searching only from one field,

here are my fields.

Table :packages

package_id        price   price_double    price_triple    price_quad

I want to search the min amount from four fields

like in php function

 min(price,price_double,price_triple,price_quad).

but I want to implement it in mysql query how can this be possible? please help me. thanks in advance.

Do you want the minimum value across all four columns? – alexn May 02 '13 at 05:55 — alexn, May 02 '13 at 05:55

score 4 · Accepted Answer · edited May 02 '13 at 06:46

4

Use LEAST:

SELECT
    package_id,
    LEAST(price, price_double, price_triple, price_quad) AS price
FROM package;

edited May 02 '13 at 06:46

alexn

57,867
14
111
145

answered May 02 '13 at 06:36

Dharmesh Patel

1,881
1
11
12

score 0 · Answer 2 · edited May 23 '17 at 12:20

0

select     case when price <= price_double and price <= price_triple and price<=price_quad then price
           when price_double <= price and price_double <= price_triple and price_double <=price_quad then price_double
          when price_triple<=price and price_triple<=price_double and pricetriple <= price_quad then price_triple
           when price_quad <= price and price_quad <= price_double and price_quad <=price_triple then price_quad
    end as 'TheMin'             

from Table packages

If you have any doubt please check this stackoverflow question link.

edited May 23 '17 at 12:20

Community

1
1

answered May 02 '13 at 06:11

Venkata Krishna

4,287
6
30
53

it getting me all rows min vlaue. – usii May 02 '13 at 06:44

score 0 · Answer 3 · answered May 02 '13 at 06:15

0

what you think about that? is it right?

   SELECT LEAST(MIN(price), MIN(price_double), MIN(price_triple), MIN(price_quad))
   AS MinOfAllColumns
   FROM packages

answered May 02 '13 at 06:15

usii

1,113
1
10
17

How to search min value from four other different fields in mysql query?

3 Answers3