[Koha] BULK EDIT BARCODES

[Ian Bays]

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 wrote:
> 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 is matching the records but changing none. Is
> there something I am missing?
>
> MariaDB[koha_library]>
> UPDATE items SET barcode = REPLACE(barcode, '%--%', '%-%') WHERE itemnumber
> IN (377,378,391,.....);
>
> I am using koha version 19.11 on Ubuntu 16.04 and mysql Ver 15.1 Distrib
> 10.0.38-MariaDB
>
> Please assist
>
> Warm Regards
> James
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>