[RESOLVED] Problems when grouping

DanielLiljeberg

I wanna do a query that's like this

SELECT search_engine, COUNT(*) as num FROM search_engine_log GROUP BY search_engine WHERE when => '$startDate' AND when =< '$endDate'

However, Where doesn't work with GROUP BY and when I try HAVING it doesn't seem to wanna work either. Any ideas?

Plasma

You have the group by and where clauses in the wrong order.

SELECT search_engine, COUNT(*) as num
FROM search_engine_log
WHERE when => '$startDate' and when <= '$endDate'
GROUP BY search_engine

Additionally, your '... when =< ' is incorrect (Atleast in common programming languages) - You need to put the less than sign first <= instead of =<.

DanielLiljeberg

Hi, thanx

But I just found it our on my own 😉
I usually mix up the >= => but I try to switch that first of all. But the main problem was the order of the GROUP BY and WHERE as you said. I had already tried to have WHERE first (actually how I wrote it first). But the MAIN problem was that where (the name of the column) had to have ` rapped around it. The it worked like a charm.