title: How to check the multiple values against a same name attribute in xml column of DB2 using XMLQuery?
body: <p>Here is my query which I'm using to fetch the data from my table.</p>
  
  <pre><code>SELECT XMLQUERY('$INFO/root/database_systems/system/@name = ("SYS1","SYS2","SYS3")') 
  FROM MyTable WHERE ACCT_ID = 'ID-1234';
  </code></pre>
  
  <p>Ok actually it is returning me true. Just because of the first value SYS1. It exists in the hierarchy but not the others. I just want to compare multiple values. </p>
  
  <p>Please suggest a way to achieve this functionality. Thanks</p>
  
  <pre><code>    &lt;root&gt;
      &lt;database_systems&gt;
      &lt;system name="SYS1"&gt;1&lt;/system&gt;
      &lt;/database_systems&gt;
      &lt;/root&gt;
  </code></pre>