title: Best way to insert multiple dates to a row in MySQL
body: <p>I have a form to book ads for multiple dates, which are selected by using a calendar in the form and then posted in JSON format. An example would be:</p>
  
  <pre><code>[20110915, [20110918, 20110925], 20110926, 20110927]
  </code></pre>
  
  <p>but I am having a problem storing this json string for each ad.</p>
  
  <ol>
  <li><em>How would you recommend storing this dates with a relation to the ad?</em></li>
  <li><em>How to select an ad using one of its dates.</em></li>
  </ol>
  
  <p>I don't want to store each date separately in different table (which makes db bulky).</p>