Exim使用正则expression式查找MySQL
我有以下工作Exim4路由器: dovecot_user: driver = accept condition = ${lookup mysql{SELECT CONCAT(mailboxes.local_part,'@',domains.fqdn) AS goto FROM domains,mailboxes WHERE \ mailboxes.local_part='${quote_mysql:$local_part}' AND \ mailboxes.active=1 AND \ mailboxes.domain_id=domains.id AND \ domains.fqdn='${quote_mysql:$domain}' AND \ domains.active=1}{yes}{no}} transport = dovecot_delivery 我想修改它,以便它可以接受表格的地址(然后发送到crm-bounce收件箱): [email protected] [email protected] 我知道以下SQL正确地从testing数据库中select: SELECT * FROM regexptest.test WHERE email REGEXP '^crm-bounce([\+].*)?$'; 我修改了这一行: mailboxes.local_part='${quote_mysql:$local_part}' AND \ 所以它写道: mailboxes.local_part REGEXP '^${quote_mysql:$local_part}([\+].*)?\$' AND \ 但是当运行exim […]