Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: MySQL 5.1 - XPath Question
03-01-2007, 01:41 PM #1
- Join Date
- Jan 2006
- Thanked 0 Times in 0 Posts
MySQL 5.1 - XPath Question
For my project I have to use the new MySQL 5 built-in XPath Support.
However, I've come across the following problem:
Sometimes XML documents have several tags of the same type. For example:
to query for the authors I use: select ExtractValue(column_name, 'book/author') from table_name;
it returns all the authors, separated with white space as follows: a1 a2 a3
This is pretty inconvenient for parsing if a single author has two names.
So, do you know any way to make MySQL return the result with any other separator string, except for white space.
I'd be very grateful if you can help!!!