: 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
that INET_ATON() was introduced in 3.23.15? We don't think it is,
and many users had complained that th
-Original 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 use
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
on
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 version
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
harenko [mailto:[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 w
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
inet_aton('xxx
Below is a query I'm trying to create and the sql for the table I'm pulling the
information out of. The query is definitely not the best query out there
especially since I'm still pretty new with sql. I know there has to be a
better way of getting the information I want. A little background.
Try this
SELECT *
FROM applications LEFT JOIN rejected ON application.appid = rejected.appid
WHERE rejected.appid Is Null
ORDER BY application.appid DESC;
>>> Wade <[EMAIL PROTECTED]> 4/23/05 3:12:37 PM >>>
04232005 1707 GMT-6
I need to do something like this:
$sql = "SELECT * FROM applicatio
Hi,
I use the following query to extract information about a practice in my
database. However if the practice system id hasnt been set then the query
won't work.
SELECT P.*, S.System_Name FROM Practices P, Systems S WHERE P.Practice_ID =
'".$_SESSION['ses_practice_id']."' AND S.System_ID = P.Sy
10 matches
Mail list logo
