- Previous message: Jevos, Peter: "RE: Full active queue"
- Maybe in reply to: Dick Middleton: "mysql domain lookups"
- Next in thread: mouss: "Re: mysql domain lookups"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
|
|
|
From: mouss (no email)
Date: Tue Sep 04 2007 - 06:16:41 EDT
Dick Middleton wrote:
> 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,'$')
>
no need for REGEXP.
query = SELECT helo FROM country WHERE
substring_index('%s', '.', -1) = code
|
|
|