Re: [exim] MySQL table lookup..

Etusivu
Poista viesti
Vastaa
Lähettäjä: Nico Erfurth
Päiväys:  
Vastaanottaja: Hubert Denkmair, exim-users
Kopio: 
Aihe: 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