[Dovecot] mysql query prepending

[Chris Cappuccio]

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 at 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 ?