asked on
MYSQL sort minimum value of 3 fields
Hi
I have 3 fields I want to sort by in MYSQL DB.
price1, price2, price3
I want to sort my result by testing each field and sorting by the minimum value of the 3
each will contain a value and they are in no order of low to high's
I have 3 fields I want to sort by in MYSQL DB.
price1, price2, price3
I want to sort my result by testing each field and sorting by the minimum value of the 3
each will contain a value and they are in no order of low to high's
MySQL ServerSQL
Last Comment
Kevin Cross
sort by (price1 + price2 + price3)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.