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 ?