MySQL 5 Could Support XPath
There’s an unofficial patch floating around for MySQL 5 that may get merged in, that’ll bring in XPath support. Looks like your select query will have to use a function called ExtractValue.
From Alexander Barkov’s slides where xml is the column name of the xml data we’re looking to index…
select ExtractValue(xml, '/section/title') from t1;