[Koha] How to extract data from marcxml.biblioitmes ?

[Vimal Kumar]

Dear Friends,
I would like to prepare a report from "marcxml" field in "biblioitems"
table.
The report should include author, title, subject and abstract.
I got some hint from koha wiki page,
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC

But I failed to  wrote an SQL query for the purpose.
I am not familiar with writing query to extract data from XML part in MySQL.
Can you help me to prepare a report from "marcxml" ?

If anybody from developers or users give guideline with examples, that will
be a good contribution to Koha community.

-- 
Vimal Kumar V.
Asst. Librarian
Asian School of Business
Technopark, Trivandrum-695 581
Web: www.vimalkumar.co.nr
Blog: http://vimalkumar.oksociety.in

OK Society Volunteer. http://oksociety.in
---------------------------------------------------------------------------
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100510/1594be65/attachment-0001.htm