From: Dick Middleton (no email)
Date: Mon Sep 03 2007 - 12:14:27 EDT
Victor Duchovni wrote:
> On Mon, Sep 03, 2007 at 10:32:48AM +0100, Dick Middleton wrote:
>> For better or worse I'm trying to setup mysql to do helo checks on a
>> country basis. I've got a table set up with the tld as the "key" and
>> query it like this:
>>
>> query = SELECT helo FROM country WHERE code = '%1'
> Sorry, the "%n" macros are not designed for domain-only lookup keys.
Well, that's a bummer :-(
Luckily mysql seems to be able to do the job but I hate to think how many cpu
cycles it uses.
query = SELECT helo FROM country WHERE '%s' RLIKE CONCAT('\\.', code,'$')
:-)
Dick
|
|
|