Re: [Dovecot] mysql query prepending

after poking around on the mysql.org manual user comments for a while, this seems to be the equivalent

user_query = SELECT CONCAT('maildir:', maildir) as mail, homedir as home, uid, gid FROM postfix_users WHERE email = '%u'

Chris Cappuccio [chris@nmedia.net] wrote:

In postgresql you can do something like

select 'maildir:' || maildir as mail, uid, ...

through dovecot-sql.conf

Is there a mysql equivalent for adding 'maildir:' as a prefix to the 'mail' location ?