title: Converting SELECT DISTINCT ON queries from Postgresql to MySQL
body: <p>I've been using <strong>PostgreSQL</strong> and now migrating to <strong>MySQL</strong>. </p>
  
  <p>In my queries, I'm using <strong>PostgreSQL</strong>'s <code>SELECT DISTINCT ON (col1, col2, col3)</code>, I was wondering if there is any counterpart of this statement in <strong>MySQL</strong>.</p>