title: selecting data from table based on date
body: <p>i have database table like this </p>
  
  <pre><code>+-------+--------------+----------+
  |   id  |    ip        |    date  |
  +-------+--------------+----------+
  |   505 |192.168.100.1 |2010-04-03|
  |   252 |192.168.100.5 |2010-03-03|
  |   426 |192.168.100.6 |2010-03-03|
  |   201 |192.168.100.7 |2010-04-03|
  |   211 |192.168.100.10|2010-04-03|
  +-------+--------------+----------+
  </code></pre>
  
  <p>how can i retirive data from this table where month=03 how to write sql to do that . </p>
  
  <pre><code>select * from table where month=03 
  </code></pre>
  
  <p>something like that . </p>