How to query SharePoint items that contain one or more text values CAML?

Question

I want to query for SharePoint items that contain at least one or more specified texts. For example, I have a field called "Pets." A SharePoint item would have a value that looks something like "Cat, Snake, Spider" or "Bear, Rat." So the number of pets will vary. If I want to only query for items that contain the words "Cat," "Dog," or "Frog," how would I do that using CAML query? The number of words I'll be checking for will be dynamic.

I tried this:

<Query>
    <Where>
        <Contains>
            <FieldRef Name='Pets' />
            <Value Type='Text'>Cat</Value>
        </Contains>
        <Contains>
             <FieldRef Name='Pets' />
             <Value Type='Text'>Dog</Value>
        </Contains>
        <Contains>
            <FieldRef Name='Pets' />
            <Value Type='Text'>Frog</Value>
        </Contains>
    </Where>
</Query>

Answer 1

You can use Or construct like:

<Query>
    <Where>
        <Or>
        <Or>
        <Contains>
            <FieldRef Name='Pets' />
            <Value Type='Text'>Cat</Value>
        </Contains>
        <Contains>
             <FieldRef Name='Pets' />
             <Value Type='Text'>Dog</Value>
        </Contains>
        </Or>
        <Contains>
            <FieldRef Name='Pets' />
            <Value Type='Text'>Frog</Value>
        </Contains>
         </Or>
    </Where>
</Query>