MySQL: How to ORDER BY on multiple columns? : <p>I have the the following columns on a table</p>

<pre><code>type | date_1 | date_2 | date_3
</code></pre>

<p>type column is </p>

<pre><code>ENUM('1','2','3')
</code></pre>

<p>I need to order by on date columns but use appropriate columns based on <code>type</code> column on every row.</p>
