I want find (and possibly select) all features from a multi-polygon that contain the names 'Angelica' and 'Anthoxanthum' in the attribute table. In this case it would be feature 1 and 6.
Is there a way to do it with a SQL query or some other tool?
I tried the 'Find tool' and the 'Select by Attribute' tool but my attribute table contains hundreds of columns.
The goal is to find (and select) every feature in which the two names 'Angelica' and Anthoxanthum' occur.
Update: As suggested by @ycartwhelen and @FelixIP
import arcpy fc = 'D:/data/myshpefile' fields = ['_Art_1', '_Art_2', '_Art_3'] set2test = set(['Pfeifengras','Herzblatt']) def queryMany(listOfSents): bigSet = set() for s in listOfSents: bigSet.update(set(s.split(" "))) return not len(set2test.difference(bigSet)) queryMany([ !_Art_1!, !_Art_2!, !_Art_3!, (.....) !_Art_82!])