Re: [Exim] mysql lookup for relay_domains

Top Pagina
Delete this message
Reply to this message
Auteur: Philip Hazel
Datum:  
Aan: Brian K. West
CC: Nancy Pettigrew, exim-users
Onderwerp: Re: [Exim] mysql lookup for relay_domains
On Fri, 14 Jul 2000, Brian K. West wrote:

> You can also use:
>
> SELECT domain FROM domain WHERE domain LIKE SUBSTRING_INDEX('$key', '.', -2)


and I seem to recall that there is a pattern matching facility in SQL,
isn't there? Can't you look up "ends with" by this means?


-- 
Philip Hazel            University of Cambridge Computing Service,
ph10@???      Cambridge, England. Phone: +44 1223 334714.