selecting data from table based on date .
- by mehdi
i have database table like this
+-------+--------------+----------+
| 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|
+-------+--------------+----------+
how can i retirive data from this table where month=03 how to write sql to do that .
select * from table where month=03
something like that .
