Re: [Exim] mysql lookup for relay_domains

Etusivu
Poista viesti
Vastaa
Lähettäjä: Philip Hazel
Päiväys:  
Vastaanottaja: Brian K. West
Kopio: Nancy Pettigrew, exim-users
Aihe: 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.