MySQL: group by and IF statement
Posted
by notset
on Stack Overflow
See other posts from Stack Overflow
or by notset
Published on 2010-05-18T20:03:27Z
Indexed on
2010/05/18
20:10 UTC
Read the original article
Hit count: 142
By default, parent_id
= 0. I want to select all records with parent_id
= 0 and only the last ones with parent_id
> 0.
I tried this, but it didn't work:
SELECT * FROM `articles`
IF `parent_id` > 0 THEN
GROUP BY `parent_id`
HAVING COUNT(`parent_id`) >= 1
END;
ORDER BY `time` DESC
What could be the solution?
© Stack Overflow or respective owner