Mysql max value from 3 different columns
max, mysql, sql
Solution
you need to use GREATEST
like that
select id from tablex where GREATEST(column1, column2, column3) > 69
Problem
Is there any way to find maximum value of 3 different columns? I'm trying to find records with any of 3 columns value higher than specified value and trying to avoid making something like this in query: ``` column1 > 69 or column2 > 69 or column3 > 69 ``` Table structure is like this: ``` id | column1 | column2 | column3 1 | 5 | 4 | 3 2 | 70 | 1 | 65 3 | 66 | 3 | 90 ``` And select like this: ``` select id from tablex where column1 > 69 or column2 > 69 or column3 > 69 -- but with better query, a bit prettier like this (it doesn't work of course) select id from tablex where MAX(column1, column2, column3) > 69 ```