From: Dave McGuire (mcguireneurotica.com)
Date: Mon Sep 03 2007 - 11:19:09 CDT

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

On Sep 3, 2007, at 12:14 PM, 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,'$')
>
> :-)

   Ouch! I hope you have query caching enabled on your database
server. ;)

          -Dave

--
Dave McGuire
Port Charlotte, FL
Farewell Ophelia, 9/22/1991 - 7/25/2007

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