title: How to Check for Multiple Conditions in Xpath
body: <p>I want to retrive <code>PName</code> of the  <strong>row/field whose id =2 and pAddress=INDIA</strong> </p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;mysqldump &gt;
  &lt;database name="MyDb"&gt;
  &lt;table name="DescriptionTable"&gt;
  &lt;row&gt;
  &lt;field name="id"&gt;1&lt;/field&gt;
  &lt;field name="pName"&gt;XYZ&lt;/field&gt;
  &lt;field name="pAddress"&gt;INDIA&lt;/field&gt;
  &lt;field name="pMobile"&gt;1234567897&lt;/field&gt;
  &lt;/row&gt;
  &lt;row&gt;
  &lt;field name="id"&gt;2&lt;/field&gt;
  &lt;field name="pName"&gt;PQR&lt;/field&gt;
  &lt;field name="pAddress"&gt;UK&lt;/field&gt;
  &lt;field name="pMobile"&gt;755377&lt;/field&gt;
  &lt;/row&gt;
  &lt;row&gt;
  &lt;field name="id"&gt;3&lt;/field&gt;
  &lt;field name="pName"&gt;ABC&lt;/field&gt;
  &lt;field name="pAddress"&gt;USA&lt;/field&gt;
  &lt;field name="pMobile"&gt;67856697&lt;/field&gt;
  &lt;/row&gt;
  &lt;/table&gt;
  &lt;/database&gt;
  &lt;/mysqldump&gt;
  
  String expression="/mysqldump/database[@name='MyDb']/table[@name='DescriptionTable']/row/field[@name='id' and ./text()]";
  </code></pre>
  
  <p><strong>Edit:</strong></p>
  
  <p>I would like to get Pname whoese id is 2 and pAddress=INDIA</p>
  
  <pre><code>String expression="/mysqldump/database[@name='MyDb']/table[@name='DescriptionTable']/row/field[@name='id' and .='2']and[@name='pAddress' and .='INDIA']/../field[@name='pName']/text()";
  </code></pre>