[snip] SELECT COUNT(DISTINCT( `cycle_flag`)) as numCycles FROM `crmReserve01`.`tblCDR` WHERE `cycle_flag` LIKE '___20__C_' [/snip]
Query kept running and although stated as 'Killed' in processlist was hung up and using resources like a hawg... 1. MySQL had to be restarted 2. Repaired the table in question Works just fine now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]