Re: [Koha] Extracting list of biblios with . in the subject

hi there..... im just using the SQL given by you and its work

If you mean this query Barton provided,

SELECT ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"]' ) as 'Topical term', biblionumber, title FROM biblio INNER JOIN biblio_metadata using (biblionumber) WHERE ExtractValue( metadata, '//datafield[@tag=650]/subfield[@code="a"]' ) rlike '\\.'

You can append one line to that query: AND title LIKE '%mechatronics%' This will limit your query to any title with "mechatronics" anywhere in the title. -- Owen -- Web Developer Athens County Public Libraries https://www.myacpl.org