[AMaViS-user] $sql_select_policy help

Hello everyone,

I'm tuning up my $sql_select_policy in order to improve functionality
of amavis on my mail server and I'm struggling with something which
I'd imagine would be simple. I need to extend this query as follows:

" ... OR alias.goto LIKE ('%RECIPIENT%')"

where RECIPIENT is the individual recipient address for the message
in question and the % signs are wrapping it in order to treat it as a
needle in a haystack. I need the same recipient address which
appears in the first set of single quotes when the %k macro is
expanded in the typical policy lookup query (per the various README
examples)...

Can anyone help me?

Thanks,
Daniel


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/