Howdy again,
Thanx go to Philip, Mark & John.
Ultimately I fixed it with the suggestion from Mark which at the time I
was too ingnorant to realise would solve my problems.
My sql table now contains
+------------+-------+
| Host | User |
+------------+-------+
|%.spam.com | * |
+------------+-------+
instead of previously having *.spam.com. And now the query looks like
this.
sender_reject_recipients = @@mysql;select user from reject_users
where '${key}' like host;
And this matches all subdomains of spam.com and with out having to use the
regex pattern matching within mysql.
Thanx again for all the help guys.
Tom Bell