I figured it out. So here is the answer in case someone else is looking for it.

Your driving...

Hi,

Thanks for article.

Does anyone know how to do this in mySQL? - I have some data in a mySQL DB and would love to view it.

I was able to convert...

Thanks for article and comments - I learnt a lot.

In MySQL 😀 this is the fastest by far:

SELECT

CustomerId

FROM Purchase

WHERE ProductCode IN ('A','B', 'C')

GROUP BY CustomerID

having sum(case when...

Hi,

I'm a bit of a newbie - so I've seen SQL has the ability to do Full Text Searching. I've never used it but why did you not use it?...

Hi Farrell,

Did you ever find a solution to your problem? I'm asking because I'm looking for something pretty much the same as what you are looking for.

Thanks,

Grant