Mysql query non-repeated data every month SQL code mysql> select * from product group by concat (year (last_update), '-', week (last_update), day (last_update )) order by last_update; or SQL code mysql> select * from product group by date_format (last_update, '% Y-% m-% D') order by last_update; www.2cto.com SQL code + ----- + response + --------------------- + | id | product | last_update | + ----- + response + --------------------- + | 154 | new Ipda-39-76 | 10:46:46 | 155 | new Ipda-64-55-58 | 10:46:46 | 156 | new Ipda-3-61-65 | 10:46:46 | 157 | new Ipda-64-22-41-50 | 10:46:46 | 159 | new Ipda-64-36-93-27 | 10:46:46 | 160 | new Ipda-3-81-97-69 | 10:46:46 | | new Ipda-64-22-99-5-64 | 2012-10-04 10:46:46 | 122 | new Ipda-71 | 2012-10-05 10:46:46 | 123 | new Ipda-64-29 | 2012-10-06 10:46:46 | 124 | new Ipda-3-34 | 2012-10-07 10:46:46 | 59 | new Ipda-39 | 10:46:46 | 60 | new Ipda-64-55 | 10:46:46 | 61 | new Ipda-3-61 | 10:46:46 | 62 | new Ipda-64-22-41 | 10:46:46 | 64 | new Ipda-64-36-93 | 10:46:46 | 65 | new Ipda-3-81-97 | 10:46:46 | 66 | new Ipda-64-22-99-5 | 10:46:46 | 1 | new Ipda | 10:46:46 | 2 | new Ipda-64 | 10:46:46 | 3 | new Ipda-3 | 10:46:46 | 4 | new Ipda-64-22 | 10:46:46 | 7 | new Ipda-64-36 | 10:46:46 | 8 | new Ipda-3-81 | 10:46:46 | 9 | new Ipda-64-22-99 | 10:46:46 | | 15 | new Ipda-3-17 | 10:46:46 | 16 | new Ipda-64-22-27 | 10:46:46 | 18 | new Ipda-64-36-38 | 10:46:46 | 19 | new Ipda-3-81-41 | 10:46:46 | 20 | new ipda-64-22-99-90 | 10:46:46 | 34 | new Ipda-3-81-26 | 10:46:46 | 35 | new Ipda-64-22-99-10 | 10:46:46 | 38 | new Ipda-3-17-70 | 10:46:46 | | 41 | new Ipda-64-36-38-44 | 10:46:46 | 42 | new Ipda-3-81-41-9 | 10:46:46 | 43 | new Ipda-64-22-99-90-13 | 10:46:46 | + ----- + ------------------------- + --------------------------------rows in set