[Dovecot] SQL field format for digest-md5?

[Darren Pilgrim]

I'm enabling digest-md5 authentication with "u...@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?