patch for wildcard matching in mysql

Joe Pruett <[email protected]> Wed, 04 Mar 2015 11:40:45 -0800
Newsgroups gmane.mail.perdition.user
Message-ID <[email protected]>
is this something that people would use? i have made a local patch that
lets me do some sql wildcard matching if there isn't an exact match in
the db. this allows me to have a front end server for multiple domains
and unless something needs special per-user handling, i can just match
on the domain and route on that. it even allows for multiple wildcard
matches and chooses the longest pattern as the best one.

for example:

%@foo.com    server1
%@bar.com    server2
%                   server3

user [email protected] goes to server1, [email protected] to server2, and [email protected] to
server3.

if this is of interest i can send the patch. or if i've just missed an
obvious way to handle this, let me know that :-).
______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users