I am wondering if anybody available as built a custom script or saved method that need a area as well as an XPath expression to come back. Even when it is clumsy, I'll go.

Something similar to this:

FindByXPath(fieldName, query);

That We gives values:

FindByXPath([xmlContent], '/root/customer/country[@attribute]');

All I want is fundamental node and attribute selection. I am using MySQL 5.

Upgrade to MySQL 5.1. It supports ExtractValue(xml_frag, xpath_expr)