title: Mysql max value from 3 different columns
body: <p>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: </p>
  
  <pre><code>column1 &gt; 69 or column2 &gt; 69 or column3 &gt; 69
  </code></pre>
  
  <p>Table structure is like this:</p>
  
  <pre><code>id | column1 | column2 | column3
  1  |   5     |    4    |    3
  2  |  70     |    1    |    65
  3  |  66     |    3    |    90
  </code></pre>
  
  <p>And select like this:</p>
  
  <pre><code>select id from tablex where column1 &gt; 69 or column2 &gt; 69 or column3 &gt; 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) &gt; 69
  </code></pre>