Kan zoekvraag niet uitvoeren: SELECT distinct trim(substring_index(place,',',-1)) as myplace, trim(place) as wholeplace, count(place) as placecount, gedcom FROM tng_places WHERE gedcom = "hsk" AND trim(substring_index(place,',',-1)) LIKE ""%" GROUP BY myplace ORDER by myplace