[Koha] New SQL Report - Missing or invalid email format

Cab Vinton bibliwho at gmail.com
Mon Jun 17 22:07:30 NZST 2013


Developer: Md. Zahid Hossain Shoeb, Independent University, Bangladesh (IUB)
Module: Patrons
Purpose: To list the patrons missing or invalid email format

SELECT surname AS Surname, firstname AS "First Name", cardnumber AS
"Card Number", email AS Email
FROM borrowers
WHERE email NOT LIKE '%_ at __%.__%'
ORDER BY email DESC


More information about the Koha mailing list