At 11:04 PM 2/10/2009, [email protected] wrote:
At 05:24 PM 2/10/2009, mouss wrote:
While I can readily create a user [email protected], who has a
default maildir location for that sql of 'example.com/bob/' I can't
quite figure out how to change the SQL to get the folder for
[email protected] to return:
'example.com/bob/Maildir/.test' without breaking everything else?
To answer my own question (more correctly)
SELECT
CONCAT(maildir,'Maildir/',if(INSTR(username,'+'),'.',''),if(INSTR(username,'+'),MID(username,INSTR(username,'+')+1,INSTR(username,'@')-INSTR(username,'+')-1),''))
FROM mailbox
Rick
