[prev in list] [next in list] [prev in thread] [next in thread] 

List:       exim-users
Subject:    Re: [exim] MySQL table lookup..
From:       Nico Erfurth <masta () perlgolf ! de>
Date:       2004-10-28 10:37:15
Message-ID: 4180CBDB.7060301 () perlgolf ! de
[Download RAW message or body]

Hubert Denkmair wrote:
> You could try to use a LIKE in your SQL query:
> SELECT '$sender_host_address' FROM global_backlist WHERE 
> '$sender_host_address' LIKE CONCAT(address,'%')

This would result in a full table scan, every time the lookup is done.

Nico

-- 
## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at \
http://www.exim.org/ ##


[prev in list] [next in list] [prev in thread] [next in thread]