29 Jul
2020
29 Jul
'20
9:45 p.m.
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