title: MYSQL - GROUP_CONCAT AND FIND_IN_SET are mixing values/order?
body: <p>I have the following problem: I try to select all the votes a user made and put them out in one column. I use <code>GROUP_CONCAT</code> for this, but somehow it is mixing the values order.</p>
  
  <p>This is the SQL code:</p>
  
  <pre><code>SELECT 
      GROUP_CONCAT(DISTINCT options.option_name SEPARATOR ',') AS selected,
      user_login.firstname, user_login.lastname,
      event.event_title
  FROM
      options, user_login, event, votes, questions
  WHERE
      event.id = ? AND questions.Event_id = event.id 
      AND votes.user_id = user_login.id AND votes.question_id = questions.id 
      AND FIND_IN_SET(options.id, selected)
  </code></pre>
  
  <p>GROUP BY 
          user_login.id
     ORDER BY 
          user_login.class</p>
  
  <p>An example value for votes would be:</p>
  
  <pre><code>id |  event_id  | question_id  |  selected   |  user_id
  25       14           42          52,46,41         1
  26       14           43             68            1
  </code></pre>
  
  <p>Options is like:</p>
  
  <pre><code>id |  option_name   | question_id
   40        Project A          42
   41        Project B          42
   46        Project C          42     
   52        Project D          42
   67        Hello              43
   68        Bye                43
  </code></pre>
  
  <p>Questions is like:</p>
  
  <pre><code>id  |  question_name  | event_id
  42     Project Number       14
  43     Greeting             14
  </code></pre>
  
  <p>Event is like:</p>
  
  <pre><code>id  |  title
  14     Project Testing
  </code></pre>
  
  <p>And the output of the given code is:</p>
  
  <pre><code>selected                            |  event_title
  Project C, Bye, ProjectD, Project B      Test
  </code></pre>
  
  <p>How can I keep the original order, so that it outputs me:
  Project D, Project C, Project B, Bye?</p>