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.
signature.asc
Description: This is a digitally signed message part
