dovecot - Dec 2008 - SQL field format for digest-md5?

I'm enabling digest-md5 authentication with "user at example.com"
username
and plain-text passwords stored in a MySQL database.  What should the 
password field contain in order to work with digest-md5?  Would the 
following:

SELECT CONCAT('{digest-md5}', MD5(CONCAT(username, '::',
password))) AS
password ...

be correct?

On Dec 23, 2008, at 8:57 PM, Darren Pilgrim wrote:
> I'm enabling digest-md5 authentication with "user at
example.com"
> username and plain-text passwords stored in a MySQL database.  What  
> should the password field contain in order to work with digest-md5?   
> Would the following:
>
> SELECT CONCAT('{digest-md5}', MD5(CONCAT(username, '::',
password)))
> AS password ...
>
> be correct?
Don't try to do anything special. Just:

SELECT username as user, password FROM ..