From: Dick Middleton (dickfouter.net)
Date: Mon Sep 03 2007 - 11:14:27 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]