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;
Props to Dan for the heads up. Apparently, Microsoft has decided to debut their new system on MTV instead of a major game convention, which as far as I know, is a first for a console manufacturer. Their choice to do this over MTV does make some sense though, as the next Xbox is going to be heavily marketed as a media center capable device.
On a quasi-related note… Does anyone know when/if MTV will show music videos again?