title: Mysql Query get Unbooked date for hotels booking room
body: <p>I have table like this, </p>
  
  <pre><code>Mst_Booking
      room_id int(11),
      order_id int(11),
      start datettime,
      end datetime
  </code></pre>
  
  <p>I can get specific date that booked by this query</p>
  
  <p><code>select * from Mst_Booking etc..,</code></p>
  
  <p>the result </p>
  
  <pre><code>1   1   2017-01-01  2017-01-08
  1   1   2017-01-11  2017-01-12
  </code></pre>
  
  <p>but I cannot get the data where have not listed in there
  like this </p>
  
  <p>"The Unbooked/ available date"</p>
  
  <pre><code>room_id     start         end
  1           2017-01-09    2017-01-10
  1           2017-01-13    2017-01-31
  </code></pre>
  
  <p>please help me should I create more table to marking the unbooked? or there is query to retrieve data as per my requirement?</p>