List:General Discussion« Previous MessageNext Message »
From:shaun thornburgh Date:May 11 2005 6:36pm
Subject:ERROR 1111 (HY000): Invalid use of group function
View as plain text  
Hi,

I keep getting thw following error when i include this line:

AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1

mysql> SELECT PRACT_NUMBER,
    -> COUNT(SUBSTRING(PRACT_NUMBER, 1, 4))
    -> FROM CSV_Upload_Data
    -> WHERE CSV_File = 'ICS'
    -> AND CHAR_LENGTH(PRACT_NUMBER) > 4
    -> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1
    -> AND Booking_ID = 6030
    -> GROUP BY PRACT_NUMBER;
ERROR 1111 (HY000): Invalid use of group function
mysql>

Can anyone tell me why this is happening?

Thanks for your advice


Thread
ERROR 1111 (HY000): Invalid use of group functionshaun thornburgh11 May
  • Re: ERROR 1111 (HY000): Invalid use of group functionPaul DuBois11 May
    • Re: ERROR 1111 (HY000): Invalid use of group functionMichael Stassen11 May
  • Re: ERROR 1111 (HY000): Invalid use of group functionStefan Kuhn11 May