Search mysql database for date range
<p>I have a database where users enter a date, among other things, with a drop down calendar, the date format is in this format   21-NOV-2012 .
Is there a way to search the database with a date range ?
I currently search date using the following ::</p>

<pre><code>sql ="SELECT * FROM ircb WHERE  date LIKE '%$term1%' AND date LIKE '%$term2%'  LIMIT $start_from, 15";
</code></pre>

<p>term1 is month and term 2 is year , this does not allow for date range within the month only for the month.
any help appreciated, thanks</p>
