Re: [Exim] mysql lookup for relay_domains

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: Brian K. West
CC: Nancy Pettigrew, exim-users
Subject: 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.