Sorry I am new to SQL and any help would be greatly appreciated
Here is my table
CREATE TABLE host_list (
number mediumint(9) NOT NULL auto_increment,
date datetime NOT NULL default '0000-00-00 00:00:00',
hostname varchar(75) NOT NULL default '',
PRIMARY KEY (number)
) TYPE=MyISAM;
here is my sql query
SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER BY
count DESC
here is my current output
283 host1
210 host2
200 host10
110 host 3
.....
1 host941
what I would like to do is list say just the hosts that have greater then 10
in the left column
Lance Rochelle
[EMAIL PROTECTED]
http://ulands.idlegames.com
(607) 775-2681
-------------------------------------------
Being a Systems Administrator is like
hitting yourself in the bead with a brick.
After a while you don't feel the pain.
--------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
