ordering my regex

["Patrick Aljord" <patcito@xxxxxxxxx>]

Hi all,

I'm doing a "select * from comments where c.content REGEXP
'http://[^i].*'" and I would like to sort the urls found by repetition
of the same urls.
As an example if I get 3 records with http://google.com url in the
content and two with http://mysql.com I would get the first the 3
comments with google.com and then the 2 with mysql.com.

Any idea how to do that?

Thanks in advance.

Pat

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx