AW: [Pdns-users] Wildcard Domains gmysql

[Steven J. Sobol]

On Wed, 30 Jul 2003, Günter Weber wrote:

> If i do the same on *.xxx.de-record with bla it looks like this
> 
> 
> select content,ttl,prio,type,domain_id,name from records where
> name='bla.xxx.de'
> select content,ttl,prio,type,domain_id,name from records where
> name='*.xxx.de'

I don't remember whether the asterisk works as a wildcard in MySQL,
but the percent sign definitely does; try using %.xxx.de instead.
 
But you'd also have to hack the gmysql backend to do name LIKE '%.xxx.de'
- which would work fine.

name like 'abc.def.g' only matches 'abc.def.g' (case insensitive)
name like '%.def.g' matches any subdomain of def.g.


-- 
JustThe.net Internet & Multimedia Svcs. [The Fusion of Content & Connectivity]
22674 Motnocab Road * Apple Valley, CA 92307-1950 
Steve Sobol, Proprietor 
888.480.4NET (4638) * 248.724.4NET * sjsobol at JustThe.net