[Dovecot] Need a little shadow to MySQL conversion help

Timo Sirainen tss at iki.fi
Tue Oct 20 19:29:38 EEST 2009


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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20091020/bbb4f496/attachment.bin 


More information about the dovecot mailing list