selecting data from table based on date .
Posted
by mehdi
on Stack Overflow
See other posts from Stack Overflow
or by mehdi
Published on 2010-04-09T12:48:05Z
Indexed on
2010/04/09
12:53 UTC
Read the original article
Hit count: 279
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 .
© Stack Overflow or respective owner
