Hello, On the above subject earlier, I wrote Ians suggestion solved my case. It sure did once but am still stuck at one point where the query finds matches but changes none with no warnings. The hyphen is just one character I'm trying to change among others. I believe the query is similar. Why aren't the changes effecting or what am I missing? My query: UPDATE items SET barcode = REPLACE(barcode, '--', '-') WHERE barcode LIKE '%--%'; RESULTS: Rows matched 1290: changed 0: Warnings 0 Please assist RegardsJames
Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Ian Bays <[email protected]> Date: 29/07/2020 23:43 (GMT+03:00) To: [email protected] 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 = 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
