20 Oct
2009
20 Oct
'09
7:29 p.m.
On Tue, 2009-10-20 at 17:57 +0200, Andreas Ntaflos wrote:
password_query = SELECT password FROM view_users WHERE email='%u';
SELECT password, email AS user FROM ..
changes username to same case as it's in the database (so lowercase probably) and there's no need to use %L anymore.
You mean something like
SELECT password, LOWER(email) as user FROM view_users WHERE email='%u'
should do the trick? I shall test this on my test server, just for fun.
Well, yes, but "email" field would most likely already be lowercased in the database, so the LOWER() wouldn't be all that useful.