title: SELECT with GROUP_CONCAT, GROUP BY, HAVING
body: <p>I Have table with odd_id and i want to select combinations for different ticket_id's. Here's my query:</p>
  
  <pre><code>SELECT
  ticket_id,
  GROUP_CONCAT(odd_id) as oddsconcat
  FROM ticket_odds
  GROUP BY ticket_id
  </code></pre>
  
  <p>And it gives me Following:</p>
  
  <pre><code>'28', '14472510,14472813,14472546,14472855,14472746,14472610,14472647'
  '29', '14471149,14471138,14471125,14475603'
  '30', '14471823,14471781,14471655,14471865,14471597,14471968,14471739,14471697,14471923'
  '31', '14473874,14473814,14473862,14473838,14473790,14473802,14473826,14473850'
  '32', '14471588,14472766,14471651,14471777,14471419'
  '33', '14472647,14472605,14471650,14471734'
  '34', '14471588,14472704,14471817'
  '35', '14475279,14474499'
  '282', '14472756,14472652,14472813'
  '283', '14471588,14472766,14471419,14471777,14471651'
  '284', '14474521'
  '285', '14474529'
  '286', '14474547'
  '287', '14471134,14471199,14473636,14471242,14471398,14471237'
  </code></pre>
  
  <p>But if i use Having function, it doesn't give me results. Clearly: it gives me for the following: </p>
  
  <pre><code>SELECT
  ticket_id,
  GROUP_CONCAT(odd_id) as oddsconcat
  FROM ticket_odds
  GROUP BY ticket_id
  HAVING oddsconcat = '14475279,14474499'
  </code></pre>
  
  <p>Returns ticket_id 35 and everyone is happy and code works fine, but if oddsconcat is larger then this one, it doesn't returns any value. for ex:</p>
  
  <pre><code>SELECT
  ticket_id,
  GROUP_CONCAT(odd_id) as oddsconcat
  FROM ticket_odds
  GROUP BY ticket_id
  HAVING oddsconcat = '14473874,14473814,14473862,14473838,14473790,14473802,14473826,14473850'
  </code></pre>