Hello, I am trying to count the number of unique records that exist in my database based on a given criteria. My table looks like this:
TABLE_HOST id host path_a path_b The field host will have duplicates like: myway.com hisway.com hisway.com hisway.com someway.com someway.com yourway.com The given criteria is: only count the records where path_a is blank (path_a='') Here is the query I'd like to run (which fails - but is exactly what I need for a query): select sum(count(host)) from TABLE_HOST where path_a='' group by host This is the next query I tried... (nothing distinct about the result of a count) select distinct count(host) from TABLE_HOST where path_a='' So, is it possible to perform this query? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
