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

[Owen Leonard]

> 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