title: ORDER BY datetime on GROUP_CONCAT not working
body: <p>I have created a table in MySQL with following columns:</p>
  
  <pre><code>id - from_id - to_id - datetime - message
  </code></pre>
  
  <p>In the the datetime column the datetime is stored like this:</p>
  
  <pre><code>2016-07-28 17:36:24
  2016-07-28 17:39:24
  2016-07-28 17:41:15
  </code></pre>
  
  <p>I amusing <code>GROUP_CONCAT</code> on <code>to_id</code> to store all messages from <code>from_id</code> and display only 1 message (the latest). My query is:</p>
  
  <pre><code>SELECT id, from_id, time_sent, message, GROUP_CONCAT(to_id order BY 
  time_sent DESC) FROM messages WHERE to_id = '1' GROUP BY from_id
  </code></pre>
  
  <p>I get all the results hroup by <code>from_id</code> but the message is the very first one. Seems like the <code>order BY time_sent DESC</code> is not been applied. </p>
  
  <p>I have tried order <code>BY UNIX_TIMESTAMP(time_sent)</code> <code>DESC</code>, tried putting order by at the end of the query. Nothing worked. I want the latest message to be displayed by <code>from_id</code>.</p>