You can extract them using SELECT biblionumber, ExtractValue(`marcxml`,'//datafield[@tag="561"]/*') FROM `biblioitems` WHERE ExtractValue(`marcxml`,'count(//datafield[@tag="561"])>0')
but only if you are using Mysql 5.1. You can use more restrictive conditions in the WHERE clause, of course. With Mysql 5.0 or lower, you can find biblios with 561 using SELECT `biblioitemnumber` FROM `biblioitems` WHERE `marcxml` LIKE '%tag="561"%' Stefano On Apr 11, 2011, at 15:07 , Elaine Bradtke wrote: > ... I need to know how to find the biblios with > information in the 561 fields, and if possible, search by specific > information in this field _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
