Re: [Koha] BULK EDIT BARCODES

e. Original message From: Ian Bays Date: 29/07/2020 23:43 (GMT+03:00) To: koha@lists.katipo.co.nz Subject: Re: [Koha] BULK EDIT BARCODES Hi. I think you do not need the % characters in the REPLACE patterns.  You could use something like: UPDATE items SET barcode = REPLAC

Re: [Koha] BULK EDIT BARCODES

Hi. I think you do not need the % characters in the REPLACE patterns.  You could use something like: UPDATE items SET barcode = REPLACE(barcode, '--', '-') WHERE barcode LIKE '%--%'; assuming you want to change all barcodes with "--". Hope this helps. On 29/07/2020 20:45, muiru james wrot

[Koha] BULK EDIT BARCODES

Hi Team, I need to edit barcodes to replace a double hyphen (--) with a single hyphen (-). The barcodes are many and will take long using the item editor which allows me to edit one after the other. Is there a SQL command I could use to edit from the terminal? I tried running the query below. It