On Tuesday, August 19, 2008 at 04:48 CEST,
Zhang Huangbin <[EMAIL PROTECTED]> wrote:
[...]
> In my record:
> ----cut<<----
> mysql> select username,restriction_class,restricteddomain from
> restrictions;
> +----------+-----------------------+------------------+
> | username | restriction_class | restricteddomain |
> +----------+-----------------------+------------------+
> | [EMAIL PROTECTED] | internal_deliver_only | b.cn |
> +----------+-----------------------+------------------+
> ----cut<<----
>
> Replace mysql lookup by hash file, it works:
> ----cut<<----
> b.cn OK
> ----cut<<----
>
> So, what SQL query should i use in mysql lookup file?
Use any query that returns "OK" is the lookup key is "b.cn".
query = SELECT "OK" FROM restrictions WHERE restricteddomain = '%s'
--
Magnus Bäck
[EMAIL PROTECTED]
