Re: [exim] MySQL table lookup..

Top Pagina
Delete this message
Reply to this message
Auteur: Nico Erfurth
Datum:  
Aan: Hubert Denkmair, exim-users
CC: 
Onderwerp: Re: [exim] MySQL table lookup..
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