[exim] Re: Replacing wildlsearch with query-style lookups?

Top Page
Delete this message
Reply to this message
Author: Jeremy Harris
Date:  
To: exim-users
Subject: [exim] Re: Replacing wildlsearch with query-style lookups?
On 1/25/24 07:36, Niels Kobschätzki via Exim-users wrote:
> I want to move my file lookups to database lookups (mariadb).
> [...] I have a problem with (n)wildlsearch. Because I just don't
> know how I could replace them.
> For example a sender-lookup for:
>
> ^.*@(.*\.)?domain\.tld$


In postgres one wa way would be something like

  sender_domains = pgsql;select substring(basedom from \
                   ".*${quote_pgsq:$sender_address_domain}")

(using a column called "basedom" with entries like
"domain.tld").

Surely MariaDB can do similar?
-- 
Cheers,
   Jeremy


--
## subscription configuration (requires account):
## https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## exim-users-unsubscribe@???
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/