I'm

I've got a little problem i match some files every day fot UPDATE my DATABASE.
I would like to count how many order start by "GOB" i've since 1 month day by day on my Table "ORDER"

```
id|last_update
gogo2132|27/08/2013 00:00:00
gob00000|27/08/2013 00:00:00
gob00001|27/08/2013 00:00:00
gob00002|27/08/2013 00:00:00
gob00003|28/08/2013 00:00:00

```

The result i need

```
Day|count"only id start by gob)
27/08/2013| 3
28/08/2013| 1

```

Thank you