From: Dave McGuire (no email)
Date: Mon Sep 03 2007 - 12:19:09 EDT
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
|
|
|