RE: [PHP] Insert group by

$sql='select count(*) as count, searchkeywords from searchkeywords group by searchkeywords having searchkeywords LIKE searchkeywords order by count desc' Ir this does not work for you explore the HAVING CLAUSE -Original Message- From: Rick Dwyer [mailto:rpdw...@earthlink.net] Sen

Re: [PHP] Insert group by

Rick Dwyer wrote: This is more of a MySQL question, but I'm hoping it can be answered here. On one of my pages, I issue a SQL command to group data as such: $sql='select count(*) as count, searchkeywords from searchkeywords group by searchkeywords order by count desc' Works well... but I would