From ec7349cb9be16e3a4d62c9ac20616354d3fc51f5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Wed, 18 May 2016 11:47:24 +0200 Subject: [PATCH] renamed to better name --- src/org/mxchange/jcontacts/contact/UserContact.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/org/mxchange/jcontacts/contact/UserContact.java b/src/org/mxchange/jcontacts/contact/UserContact.java index 387e027..fe17b21 100644 --- a/src/org/mxchange/jcontacts/contact/UserContact.java +++ b/src/org/mxchange/jcontacts/contact/UserContact.java @@ -69,7 +69,7 @@ import org.mxchange.jphone.phonenumbers.landline.LandLineNumber; @NamedQuery (name = "AllContactEmailAddresses", query = "SELECT c.contactEmailAddress FROM contacts AS c ORDER BY c.contactId ASC"), @NamedQuery (name = "AllContactsByCellphone", query = "SELECT c FROM contacts AS c WHERE c.contactCellphoneNumber = :cellPhone ORDER BY c.contactId ASC"), @NamedQuery (name = "SearchContactById", query = "SELECT c FROM contacts AS c WHERE c.contactId = :contactId"), - @NamedQuery(name = "SearchContactByEmailAddress", query = "SELECT c FROM contacts AS c WHERE c.contactEmailAddress = :emailAddress") + @NamedQuery (name = "SearchContactByEmailAddress", query = "SELECT c FROM contacts AS c WHERE LOWER(c.contactEmailAddress) LIKE LOWER(:emailAddress)") } ) @SuppressWarnings ("PersistenceUnitPresent") -- 2.39.5