> 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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
