Re: [exim] MySQL table lookup..

Top Page
This message is part of the following thread:
M+\the complete thread tree sorted by date
MMMHubert Denkmair at <-
M 
Delete this message
Reply to this message
Author: Nico Erfurth
Date:  
To: Hubert Denkmair, exim-users
CC: 
Subject: 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


This message was posted to the following mailing lists:
Exim-users
Mailing List Info | Nearby Messages		<-Re: [exim] IRIX build: daemon.c won't compile[exim] spamhaus.org->
Tahini and Hummus and Cumin Development Archives administrated by cumin AdminsLurker (version 2.3)