Query on sql lookups and order of searches

[Benedict White]

I am running some tests on a server, and have an sql server (MariaDB) running the 
schema that comes with the latest version of Amavisd-new. I use the same dsn for
storage and lookups.

What I'm trying to achieve is this:

I want to apply policy 1 to a user with an email of bob at somedomain.co.uk, and
A different policy (as it happens 12) to all other users at the same domain.

As I understand it from http://www.ijs.si/software/amavisd/README.lookups I can do this 
by having an entry (users:email)  I presume in users with @.somedomain.co.uk with a policy ID of 12
and another user with an email address bob at somedomain.co.uk with a policy id of 1. 

However it seems if I do it like that the policy of 12 applies regardless.  I've also tried 
. at somedomain.co.uk but that just makes the policy for bob at somedomain.co.uk apply to all users.

Kindest regards,

Benedict White