> 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 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
