MySQL Forums
Forum List  »  General

Re: Searching on a field from multiple rows matching a groupId
Posted by: Jerry Malcolm
Date: May 21, 2019 10:49AM

Another clarification...

In "pseudo code" what I'm looking for is:

SELECT GROUPID from myTable where
[concatentated string of COLX values from all rows with this groupId] like '%abc%'
AND
[concatentated string of COLX values from all rows with this groupId] like '%xyz%'

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.