Re: [exim] MySQL table lookup..

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Nico Erfurth
Ημερομηνία:  
Προς: Hubert Denkmair, exim-users
Υ/ο: 
Αντικείμενο: 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