<?xml version="1.0"?>
<mysqldump >
<database name="MyDb">
<table name="DescriptionTable">
<row>
<field name="id">1</field>
<field name="pName">XYZ</field>
<field name="pAddress">INDIA</field>
<field name="pMobile">1234567897</field>
</row>
<row>
<field name="id">2</field>
<field name="pName">PQR</field>
<field name="pAddress">UK</field>
<field name="pMobile">755377</field>
</row>
<row>
<field name="id">3</field>
<field name="pName">ABC</field>
<field name="pAddress">USA</field>
<field name="pMobile">67856697</field>
</row>
</table>
</database>
</mysqldump>

String expression="/mysqldump/database[@name='MyDb']/table[@name='DescriptionTable']/row/field[@name='id' and ./text()]";

String expression="/mysqldump/database[@name='MyDb']/table[@name='DescriptionTable']/row/field[@name='id' and .='2']and[@name='pAddress' and .='INDIA']/../field[@name='pName']/text()";

/mysqldump/database[@name = "MyDb"]/table[@name = "DescriptionTable"]/row[field[@name eq "id"][text() = "2"]]/field[@name = "pName"]

/mysqldump/database[@name='MyDb']/table[@name='DescriptionTable']/row/field[@name='id'][.='2']/following-sibling::field[@name='pName']/text()

/mysqldump/database/table/row/field[@name='id' and .=2]/../field[@name='pName']

/mysqldump/database/table/row/field[@name='id' and .=2]

../

field[@name='pName']

/mysqldump
/database[@name='MyDb']
/table[@name='DescriptionTable']
/row[
        field[@name[.='id'] and .=2]
            and
        field[@name[.='pAddress'] and .='INDIA']
    ]
/field[@name='pName']

/mysqldump
/database[@name='MyDb']
/table[@name='DescriptionTable']
/row[
        field[@name[.='id'] and .=2]
            or
        field[@name[.='pAddress'] and .='INDIA']
    ]
/field[@name='pName']

String expression = "/mysqldump/database[@name='MyDb']/table[@name='DescriptionTable']/
    row[./field[@name="id"]/text()="2" and ./field[@name="pAddress"]/text()="INDIA"]
/field[@name="pName"]/text()";

//row/field[text()='2' OR text()='INDIA']/../field[@name='pName']/text()

//row/field[text()='2' OR text()='INDIA']/../field[@name='pName']