[Koha] Regarding updating Patron messaging preferences

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