Re: [Exim] mysql lookup for relay_domains

Página superior
Eliminar este mensaje
Responder a este mensaje
Autor: Philip Hazel
Fecha:  
A: Brian K. West
Cc: Nancy Pettigrew, exim-users
Asunto: 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.