[Koha] Regarding updating Patron messaging preferences

[Sahadeo Taware]

We are using koha software for our library (version 16.05.05.000) on ubuntu
server

Presently we are sending email alert for overdue, checkin, checkout, predue
and due
But now we want to send email alert only for overdue and predue and not for
checkin and checkout

How can I update the all patron messaging preferences in a single query
-- 
Sahadeo D. Taware
Librarian, M.L.I.Sc., NET
Thakur College of Science and Commerce
Thakur Village, Kandivli(E), Mumbai 400101
Mob. No 9324912816
Office 28870627 Extn. 126