Re: [Koha] SQL help - Retrieve itemnumbers based on local subject keyword

2016-10-21 Thread Josef Moravec
; www.rcmusic.ca > > > -Original Message- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Craig > Butosi > Sent: October-21-16 12:54 PM > To: koha@lists.katipo.co.nz > Subject: [Koha] SQL help - Retrieve itemnumbers based on local subject > keyword &g

Re: [Koha] SQL help - Retrieve itemnumbers based on local subject keyword

2016-10-21 Thread Craig Butosi
o.co.nz] On Behalf Of Craig Butosi Sent: October-21-16 12:54 PM To: koha@lists.katipo.co.nz Subject: [Koha] SQL help - Retrieve itemnumbers based on local subject keyword Hi all, Koha 16.05.03 on Ubuntu 14.04 LTS (package install) I need to batch modify a subset of records in our db. I have to u

[Koha] SQL help - Retrieve itemnumbers based on local subject keyword

2016-10-21 Thread Craig Butosi
Hi all, Koha 16.05.03 on Ubuntu 14.04 LTS (package install) I need to batch modify a subset of records in our db. I have to use itemnumbers rather than barcodes to populate the list because not all of the records to be modified have a barcode. I've tried the following SQL to no avail: SELECT