Hello.
Usually working with IP addresses in a numeric form is faster. Use
INET_NTOA() and INET_ATON() functions to store IP addresses as unsigned
ints. To work with subnetworks instead of like 'xxx.xxx.%' use
ip_address_in_numeric_form between inet_aton('xxx.xxx.0.0') and
:[EMAIL PROTECTED]
Sent: Fri 1/6/2006 5:28 AM
To: mysql@lists.mysql.com
Subject: Re: Help with a SELECT query
Hello.
Usually working with IP addresses in a numeric form is faster. Use
INET_NTOA() and INET_ATON() functions to store IP addresses as unsigned
ints. To work with subnetworks
Jay Paulson (CE CEN) wrote:
This helps a ton! Thanks! I didn' tknow about the INET_NTOA() or the
INET_ATON() functions. That is much quicker to query on them than on a char set
of ips. However, I did notice on the mysql web site that these functions are
only available in 5.x but the way the page
Hello.
These functions are available in 4.1.16 as well:
mysql select inet_aton('192.168.0.1');
+--+
| inet_aton('192.168.0.1') |
+--+
| 3232235521 |
+--+
1 row in set (0.06 sec)
mysql select
Michael,
thanks for your feedback!
Jay Paulson (CE CEN) wrote:
This helps a ton! Thanks! I didn' tknow about the INET_NTOA() or the
INET_ATON() functions. That is much quicker to query on them than on a
char set
of ips. However, I did notice on the mysql web site that these
functions are
Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]
Sent: Fri 1/6/2006 12:40 PM
To: Michael Stassen
Cc: Jay Paulson (CE CEN); Gleb Paharenko; mysql@lists.mysql.com; [EMAIL
PROTECTED]
Subject: Re: Help with a SELECT query
[1] The reasoning behind this: Is it relevant for a 5.0 user to know
@lists.mysql.com; [EMAIL PROTECTED] Subject: Re: Help
with a SELECT query
[1] The reasoning behind this: Is it relevant for a 5.0 user to know
that INET_ATON() was introduced in 3.23.15? We don't think it is,
and many users had complained that the manual was full of clutter
like that.
Regards
Best I can come up with is something like
2 words:
SELECT c1.id
FROM crossref c1, crossref c2
WHERE c1.word='word1'
AND c2.word='word2'
AND c1.id=c2.id
3 words:
SELECT c1.id
FROM crossref c1, crossref c2, crossref c3
WHERE c1.word='word1'
AND c2.word='word2'
AND
Hi!
Query:
-
select a.id
from crossref a
, crossref b
, crodsref c
where a.id=b.id
and a.id=c.id
and a.word= word1
and b.word= word2
and c.word= word3;
It isn't ideal construction, but it works.
For your example (two words - tintin register):
select a.id from