Re: MySQL 5.1 - XPath Question

[Jonathan Stephens]

Hi!

If you don't want to use separate <firstname> and <lastname> elements, a quick workaround might be to substitute some character for the spaces in the names - say, '|' - that would never be used in a name, then replace it with a space again after extracting the names from the XML.

There may be a better solution - I'll think about it and get back to you if I can come up with something better.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle