From: "Алексей Шенцев" <ashen@nsrz.ru>
To: ALT Linux Community general discussions <community@lists.altlinux.org>
Subject: Re: [Comm] Проверка по regexp вхождения IP в подсеть
Date: Tue, 19 Feb 2008 18:40:14 +0300
Message-ID: <200802191840.14461.ashen@nsrz.ru> (raw)
In-Reply-To: <20080219153021.GF30446@ricom.ru>
В сообщении от Tuesday 19 February 2008 18:30:21 Alexey Morsov написал(а):
> On Tue, Feb 19, 2008 at 04:42:29PM +0200, Slava Dubrovskiy wrote:
> > Это конечно хорошо. Есть и перловый
> > модуль Net-IP-Match-Regexp. Но у меня есть база, в
> > которой хранятся IP в виде 192.168.1.0/24 и нужно
> > sql запросом проверять вхождение IP в сеть.
>
> /192\.168\.1\.(\d{1,3})/ ?
А можно пойти через соответствующие функции mysql'а и двоичную логику.
--
С уважением Шенцев Алексей Владимирович.
E-mail: ashen@nsrz.ru
XMPP: ashen@altlinux.org, AlexShen@jabber.ru
ICQ: 271053845
next prev parent reply other threads:[~2008-02-19 15:40 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-02-19 14:06 Slava Dubrovskiy
2008-02-19 14:18 ` Vladimir Karpinsky
2008-02-19 14:42 ` Slava Dubrovskiy
2008-02-19 15:30 ` Alexey Morsov
2008-02-19 15:40 ` Алексей Шенцев [this message]
2008-02-20 7:53 ` Slava Dubrovskiy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=200802191840.14461.ashen@nsrz.ru \
--to=ashen@nsrz.ru \
--cc=community@lists.altlinux.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux Community general discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
public-inbox-index community
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.community
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git