[Koha] Help needed finding info in non-indexed fields

[Stefano Bargioni]

You can extract them using

SELECT biblionumber, ExtractValue(`marcxml`,'//datafield[@tag="561"]/*')
FROM `biblioitems`
WHERE ExtractValue(`marcxml`,'count(//datafield[@tag="561"])>0')

but only if you are using Mysql 5.1.
You can use more restrictive conditions in the WHERE clause, of course.

With Mysql 5.0 or lower, you can find biblios with 561 using

SELECT `biblioitemnumber`
FROM `biblioitems`
WHERE `marcxml` LIKE '%tag="561"%'

Stefano

On Apr 11, 2011, at 15:07 , Elaine Bradtke wrote:

> ... I need to know how to find the biblios with
> information in the 561 fields, and if possible, search by specific
> information in this field