Re: [Exim] mysql lookup for relay_domains

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Philip Hazel
Dátum:  
Címzett: Brian K. West
CC: Nancy Pettigrew, exim-users
Tárgy: 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.