Matching XML values in MySQL

I need some keep matching values in MySQL. I have the following xml data in a single text field in MySQL

<ns1:Address1>
 <ns1:postTown>London</ns1:postalTown>
 <ns1:county>London</ns1:county>
 <ns1:country>UK</ns1:country>
 <ns1:postcode>TE1 001</ns1:postcode>
  <ns1:AddressSplit1>
   <ns1:propertyNumber>62</ns1:propertyNumber>
   <ns1:propertyName>Flat 502</ns1:propertyName>
   <ns1:streetName>Test Street</ns1:streetName>
   <ns1:locality>Test</ns1:locality
 </ns1:AddressSplit1>
</ns1:Address1>

I want to write a query to find all fields where both propertyNumber and propertyName have values, excluding spaces and dots.

Can anyone help?

Thanks