If your Koha uses MySQL 5.1, you can try something like SELECT ExtractValue(`marcxml`,'//datafield[@tag="100"]/subfield[@code="a"]') v FROM `auth_header` WHERE ExtractValue(`marcxml`,'count(//datafield[@tag="100"])>0') ORDER BY v
This example extracts 100$a from the auth_header.marcxml column. HTH. Stefano On Apr 6, 2011, at 19:19 , Peel Lisa wrote: > Hello > > I need to create a list of all authorities which I can export to excel. There > do not seem to be any examples of these on the SQL Report Library, so if > anyone could help me I would really appreciate it – I am trying to clean up > our authorities and it is very time consuming doing this just through the > Authorities module. > > Regards > > Lisa _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
