select best price between MYSQL columns and rows

[niko-cola]

Hi all! and happy new year, off course! ))

I need to get the best price between columns and also rows.

i got a table like this
inputs - price1 - price02 - price3
v1 - 90 - 92 - 110
v2 - 85 - 95 - 100

I'm getting the minimal price of each input but can't get the absolute minimal price.

Thanks in advance.

[niko-cola]

Originally Posted by niko-cola

Hi all! and happy new year, off course! ))

I need to get the best price between columns and also rows.

i got a table like this
inputs - price1 - price02 - price3
v1 - 90 - 92 - 110
v2 - 85 - 95 - 100

I'm getting the minimal price of each input but can't get the absolute minimal price.

Thanks in advance.

nobody knows how to make it? or would you need me to explain better my problem?

[Fumigator]

Try using the LEAST() function, in conjunction with MIN().

http://dev.mysql.com/doc/refman/5.0/...function_least