[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