title: Get 30 minutes interval data between start and end time in mysql
body: <p>I have table structure in mysql,</p>
  
  <pre><code>table_id  no_people  booking_date  bookingend_time      bookingstart_time
        14          2  2014-10-31    2014-10-31 13:30:00  2014-10-31 11:00:00
         5          4  2014-10-31    2014-10-31 16:30:00  2014-10-31 14:30:00
         6          2  2014-10-31    2014-10-31 17:00:00  2014-10-31 16:00:00
         2          4  2014-11-06    2014-11-06 12:30:00  2014-11-06 10:00:00
         2          4  2014-10-31    2014-10-31 16:00:00  2014-10-31 14:00:00
         3          4  2014-11-01    2014-11-01 09:00:00  2014-11-01 07:30:00
         6          2  2014-11-01    2014-11-01 10:00:00  2014-11-01 07:30:00
         2          4  2014-11-03    2014-11-03 10:30:00  2014-11-03 08:30:00
         5          4  2014-11-04    2014-11-04 10:30:00  2014-11-04 08:30:00
         3          4  2014-11-05    2014-11-05 09:30:00  2014-11-05 07:30:00
        14          2  2014-11-05    2014-11-05 09:30:00  2014-11-05 07:30:00
  </code></pre>
  
  <p>I want to retrieve table_id data with 30 minutes of interval between start and end time.</p>
  
  <p>Ex: 
   if i give booking start time 10:30 and end time 12:30 i should get 14 as row..
  Similarly it should check all rows and return between two times ..</p>
  
  <p>My query so far</p>
  
  <pre><code>SELECT `table_id` FROM `booking` WHERE bookingstart_time&gt;='2014-10-31 10:30:00' AND bookingend_time&lt;='2014-10-31 11:30:00'
  </code></pre>