Hi, On Thu, Oct 1, 2015 at 1:36 PM, Shell, Lezlie <lezlie.sh...@contractor.cengage.com> wrote: > After fleeing Brio I looked at the tables in SchemaSpy. Does the MARC data > really > live in the marc field of the biblioitem table? I tried to look at this in > Brio, > but it said I couldn't request a binary datatype. I currently do a lot of > data > checking in the marc0 table. I was hoping to find an equivalent table in > Koha.
The marcxml column in the biblioitems table also stores a copy of the record in MARCXML (using the MARC21slim schema, specifically). To get at specific values in the MARCXML, you can use MySQL's ExtractValue() SQL function; some examples can be found here: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC Regards, Galen -- Galen Charlton Infrastructure and Added Services Manager Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
