I have a database I'm trying to cross reference for duplicates.
The members table has a list of entries where it's stored with a Members row with each ID comma separated.
So it could be Members: 271,612,614,6600,1102
If I do a duplicates report it is set to take each record and break it up searching on each entry, however since I have the query doing a search such as
SELECT * FROM `Group` WHERE `Members` LIKE '%$memberquery%'
of course if Member ID 660 is looked up it'll also see Member 6600.
Could there be an easier way to Query it or should I do something like a strlen($meberquery) to then discard if it's irrelevant?