[Koha-devel] SQL for 856 tag in marc record
David Schuster
dschust1 at tx.rr.com
Wed Jan 27 14:31:39 CET 2010
Well I'm getting closer, but that only provided me with a response of 40 and
I know I have well over 3000 urls in records.
Wonder why the rest didn't populate? They show up in the catalog...
David Schuster
Frederic Demians wrote:
>
>
>> 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 at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>
>
--
View this message in context: http://old.nabble.com/SQL-for-856-tag-in-marc-record-tp27329118p27339116.html
Sent from the Koha - Dev mailing list archive at Nabble.com.
More information about the Koha-devel
mailing list