[Koha] SQL help - Bulk Card Number modification

[Ramakant]

Dear Satish,

 

With the help of sql query you will resolve your problem.

Make your data in excel sheet  then use below query for the same and resolve
your query in bulk

e.g. update borrowers set cardnumber = '4GH17ME18' where cardnumber =
'17ME01';

 

 

Regards,

 

============================================================================
===========

Ramakant

Senior Library Information Assistant

P K Kelkar Library

Indian Institute of Technology Kanpur - 208 016

Email - ramakant at iitk.ac.in, ramakant.iitk at gmail.com 

Phone: 0512 6797707 (O), +91 8090049089 (Mo.)