Hi all,

Just a simple error I hope [img]images/smilies/smile.gif[/img]

What's wrong with this?

SELECT * FROM blog GROUP BY date WHERE date LIKE '200305%' LIMIT 0 , 30

This is the error I'm getting:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE date LIKE '200305%' LIMIT 0, 30' at line 1

Thanks [img]images/smilies/smile.gif[/img]