mysql最大三个值,来自3个不同列的MySQL最大值

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

解决方案

you need to use GREATEST

like that

select id from tablex where GREATEST(column1, column2, column3) > 69