[Koha] SQL search subjects [was: To whom it may concern]
paul.a at navalmarinearchive.com
Fri Oct 7 04:29:13 NZDT 2016
At 12:03 PM 10/6/2016 +0000, Akin Adigun (Akinomatics) wrote:
>SQL query Â to seach for library items using the subjects
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.
More information about the Koha