AW: AW: [Pdns-users] Wildcard Domains gmysql

Günter Weber docc at
Wed Jul 30 19:30:49 UTC 2003

-----Ursprüngliche Nachricht-----
Von: Steven J. Sobol [mailto:sjsobol at] 
Gesendet: Mittwoch, 30. Juli 2003 21:26
An: Günter Weber
Cc: 'Christian Arnold'; pdns-users at
Betreff: Re: AW: [Pdns-users] Wildcard Domains gmysql

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

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

>I don't remember whether the asterisk works as a wildcard in MySQL,
>but the percent sign definitely does; try using instead.
>But you'd also have to hack the gmysql backend to do name LIKE
>- 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.

The entry in the record table ist * because this is the
wildcardentry for a domain (rfc haumichblau) and has nothing to do with
the wildcard of mysql, which would heavily decrease the performance by
the way ;)

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

More information about the Pdns-users mailing list