title: Is there ANY_VALUE capability for mysql 5.6?
body: <p>currently im working with mysql 5.7 in development, and 5.6 in production. Each time i run a query with a group by in development i get some error like "Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY "</p>
  
  <p>Here is the query.</p>
  
  <pre><code>SELECT c.id, c.name, i.* 
   FROM countries c, images i 
  WHERE i.country_id = c.id
  GROUP BY c.id; Fixed for 5.7; 
  
  SELECT c.id, c.name,
         ANY_VALUE(i.url) url, 
         ANY_VALUE(i.lat) lat, 
         ANY_VALUE(i.lng) lng 
    FROM countries c, images i
   WHERE i.country_id = c.id
   GROUP BY c.id;
  </code></pre>
  
  <p>For solving that I use the mysql function from 5.7 ANY_VALUE, but the main issue is that its not available in mysql 5.6</p>
  
  <p>So if I fix the sql statement for development i will get an error in production.</p>
  
  <p>Do you know any solution or polifill for the ANY_VALUE function in mysql 5.6?</p>