Distinct XML values mysql
To get the first author of the first book, you can use

select ExtractValue(xml_doc, '//book[1]//author[1]');


To get a real distinct list you would have to write a stored function that circles through all books and all authors.