This is part of a much larger project in modelbuilder. I want to use the make feature layer tool to query a field that has multiple values in each record. For example, the field name is "Animal" and the value would be "zebra, cat, horse, dog" (without quotes) for each record. How can I setup the query to search for all the animals? There are some records that only have one value in which case I can just set the query to = the field but when the field has multiple entries for each records, I'm not sure how to setup the query. I need something like "Animal" IN ('zebra', 'cat', 'horse', 'dog') But how would I add the single quotes and the parenthesis to the field value(s)?
I'm using ArcGIS 10.2.2 and all values in the field are separated by a comma and a space.
Edit: I should have been a little more clear in my original post. This query is going thru an iterator and each time the query will be different (there are hundreds of animals). The field itself has to pass thru the iterator for the query so I'm wondering how I can accomplish this. I've included a screenshot of the current model. Circled in red is where the field passes thru the "Get Field Value" tool and I then need to use that value to query a separate layer of "animals" and select all the animals in the "animal" layer there are in the "animal" field from the first layer. In essence I need to figure out how the field can be modified to feed directly into the query.