[Koha-devel] SQL for 856 tag in marc record
Frederic Demians
frederic at tamil.fr
Tue Jan 26 22:30:23 CET 2010
> Anyone have a suggestion on how to get at least a count of these 856's
> in the
> MARC record in my database?
SELECT COUNT(url) FROM biblioitems;
will give you the number of biblio records having at least one 856. A
biblio record with several 856 tags will be count as 1 url.
If you want something more efficient, you could try to add an index
named 'url' to your zebra configuration pointing to 856$t (and even
other MARC subfields containing URLs). Then re-index. This PQF search
will return exactly all records having something in 'url' field:
@attr 1=url @attr 2=103 ""
But same problem than with MySQL alternative. Maybe a zebra scan command
could help. Don't know how exactly.
--
Frédéric
More information about the Koha-devel
mailing list