Does not contain

[JKWA]

I need to perform a query similar to below

SELECT GROUP_CONCAT(foo), bar

FROM table

GROUP BY bar

HAVING GROUP_CONCAT(foo) DOES NOT CONTAIN "string";

I've looked at using a regular expression but have so far come up empty.  

Any suggestions?

Joe

[Siddartha Naidu]

Is this what you are looking for:

SELECT bar, GROUP_CONCAT(foo) list FROM table

GROUP BY bar HAVING NOT(list CONTAINS "string");

[JKWA]

Ahh, I see now.

I had this:

HAVING COUNT(foo) > 2 NOT list CONTAINS "string" 

But needed to write this:

HAVING COUNT(foo) > 2 AND NOT list CONTAINS "string"  

Thanks for the help Siddarth.