Hi Satish, On Fri, Apr 1, 2016 at 12:55 PM, SATISH <[email protected]> wrote: > Thank you Suzon, but I have a range or list of specific barcodes > identified to be kept in reference, > ex: 1, 253, 588 etc, it is random. > In this case, in SQL, > should I write. > > UPDATE items SET notforloan =1, > location = 'REF' WHERE barcode = '1', '253' <snipped>
You are approaching the issue from a more difficult and IMHO a *bad* angle, especially since you are not adept at SQL and you are trying to directly edit the database, which should be avoided as far as possible. What you *should* be using in this case is follow http://manual.koha-community.org/3.22/en/batchmodifyitems.html I'm assuming you are using the latest Koha i.e. 3.22 series. cheers -Indranil -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 IRC : indradg on irc://irc.freenode.net Twitter : indradg Facebook : https://www.facebook.com/l2c2technologies/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
