At 12:03 PM 10/6/2016 +0000, Akin Adigun (Akinomatics) wrote:
SQL query  to seach for library items using the subjects
thanks
Following for 650a -- modify as required.
mysql> SELECT biblionumber FROM biblioitems WHERE ExtractValue( marcxml,
'//datafield[@tag="650"]/subfield[@code>="a"]' ) LIKE "%search term%";
Note the wildcards around the search term; if you don't use them and have
multiple 650 entries, then the query will fail.
Paul
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
