mysql grouping in script

robsgaming

I'm trying to figure out a query for a script of mine that will group by date.

However, the dates have added times on them such as:

2003-08-01 13:07:59

I'm trying to group by the DATE only, not the time. I was wondering if there was a LIKE statement or something that can do this.

What I'm trying to do is count the total number of orders in a database grouped by the date.

Thanks in advance for any help.

Buddha443556

There's the substring function?

SUBSTRING(str,pos)
SUBSTRING(str FROM pos)
SUBSTRING(str,pos,len)
SUBSTRING(str FROM pos FOR len)
The forms without a len argument return a substring from string str starting at position pos. The forms with a len argument return a substring len characters long from string str, starting at position pos. The forms that use FROM are SQL-92 syntax.
mysql> SELECT SUBSTRING('Quadratically',5);
-> 'ratically'
mysql> SELECT SUBSTRING('foobarbar' FROM 4);
-> 'barbar'
mysql> SELECT SUBSTRING('Quadratically',5,6);
-> 'ratica'

This function is multi-byte safe.

http://www.mysql.com/doc/en/String_functions.html