Mysql counting reoccuring queries

How can I ORDER BY the count(*) results descending or ascending? Also is it possible to count LIKE queries?

     $sql= \"select Search, count(*)
                  from querylist
                  group by Search \";

Doug wrote:

How can I ORDER BY the count(*) results descending or ascending? Also is it possible to count LIKE queries?

     $sql= \"select Search, count(*)
                  from querylist
                  group by Search \";

SELECT
Search, count(*) AS cnt FROM log
from querylist
GROUP BY Search
ORDER BY cnt DESC

whoops!!!

SELECT
Search, count(*) AS cnt
from querylist
GROUP BY Search
ORDER BY cnt DESC

Bretticus

This works great thanks, do you know how I can count similar queries? using the LIKE or FULLTEXT function?

Not too familar with FULLTEXT, however with LIKE, you will get one result with the query...right?

SELECT
Search, count(*) AS cnt
from querylist
WHERE search LIKE '%expression%'

So you won't neccessarily need to order cnt in this situation, unless you group by some other field that you're not using LIKE on I suppose:

SELECT
Search, count(*) AS cnt
from querylist
WHERE search2 LIKE '%expression%'
GROUP BY Search
ORDER BY cnt DESC