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