| Ariel Sánchez Mora 2006-02-25, 9:43 am |
| Probably the problem is in php, or, more probably, in how you store =
first and then look for the IP address in your query. You should try =
your query in the mysql console; varchars work almost with anything and =
I put this example where I look for an IP address with your table, and =
it finds it correctly.
Hope this helps; if you can't find the problem, try little steps with=20
select * from portal_forums_users where ip =3D '192.168.1.0';
To try and find where you have a problem. You can even try=20
select * from portal_forums_users where ip like '%192.168.1.0%';
The % are wildcards, and that would take care of periods you =
inadvertenly added/erased. I really think this is not a MySQL problem.
mysql> describe portal_forums_users;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| user_id | bigint(255) | | PRI | NULL | auto_increment |
| ip | varchar(200) | YES | | NULL | |
| signup_date | varchar(30) | YES | | NULL | |
| city | varchar(200) | YES | MUL | NULL | |
| state | varchar(100) | YES | | NULL | |
| email_address | varchar(200) | YES | | NULL | |
| username | varchar(100) | YES | | NULL | |
| password | varchar(100) | YES | | NULL | |
| yim | text | YES | | NULL | |
| aol | text | YES | | NULL | |
| web_url | text | YES | | NULL | |
| post_count | varchar(255) | YES | | NULL | |
| info | text | YES | | NULL | |
| sig | text | YES | | NULL | |
| avatar | text | YES | | NULL | |
| css_id | int(11) | YES | | NULL | |
| mod_f | varchar(20) | YES | | NULL | |
| admin | varchar(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
18 rows in set (0.00 sec)
mysql> select * from portal_forums_users;
+---------+-------------+-------------+------+-------+---------------+---=
-------+----------+------+------+---------+------------
| user_id | ip | signup_date | city | state | email_address | =
username | password | yim | aol | web_url | post_count
+---------+-------------+-------------+------+-------+---------------+---=
-------+----------+------+------+---------+------------
| 1 | 192.168.1.0 | x | x | x | x | x =
| x | x
| x | x | x | x | x | x | 0 | x =
| x |
| 2 | 10.100.1.1 | y | y | y | y | y =
| y | y | y | y | y
+---------+-------------+-------------+------+-------+---------------+---=
-------+----------+------+------+---------+------------
2 rows in set (0.00 sec)
mysql> select * from portal_forums_users where ip =3D '192.168.1.0';
+---------+-------------+-------------+------+-------+---------------+---=
-------+----------+------+------+---------+------------
| user_id | ip | signup_date | city | state | email_address | =
username | password | yim | aol | web_url | post_count
+---------+-------------+-------------+------+-------+---------------+---=
-------+----------+------+------+---------+------------
| 1 | 192.168.1.0 | x | x | x | x | x =
| x | x
| x | x | x | x | x | x | 0 | x =
| x |
+---------+-------------+-------------+------+-------+---------------+---=
-------+----------+------+------+---------+------------
1 row in set (0.00 sec)
-----Mensaje original-----
De: CodeHeads [mailto:ch@code-heads.com]=20
Enviado el: mi=E9rcoles, 22 de febrero de 2006 17:35
Para: Ariel S=E1nchez Mora
CC: mysql@lists.mysql.com
Asunto: RE: Number Searches
On Wed, 2006-02-22 at 16:49 -0600, Ariel S=E1nchez Mora wrote:
> So far i've been able to store ip addresses as strings like you would=20
> type them in DOS, for ex, '192.168.0.1'. This serves me great since my =
> application uses IP addresses as strings in all cases. I've done=20
> queries with the IP column , for example, select office_name from=20
> table_1 where ip=3D'10.100.1.1'; and have never had any problems.=20
> However, if you plan on sorting based on this column, strings with=20
> periods do not behave correctly, and the answers to my previous=20
> question on this list do not apply; it makes a good aproximation,=20
> though.
>=20
> Hope this helps, but I must admit I am not sure if this answers your=20
> question. An example in the mysql console would be great for clearing=20
> up your objetive.
>=20
> Regards,
>=20
> Ariel
OK, I think I did not explain things right the first time. :(
I have a table like so:
CREATE TABLE `portal_forums_users
` (
`user_id` bigint(255) NOT NULL auto_increment,
`ip` varchar(200) default NULL,
`signup_date` varchar(30) default NULL,
`city` varchar(200) default NULL,
`state` varchar(100) default NULL,
`email_address` varchar(200) default NULL,
`username` varchar(100) default NULL,
`password` varchar(100) default NULL,
`yim` text,
`aol` text,
`web_url` text,
`post_count` varchar(255) default NULL,
`info` text,
`sig` text,
`avatar` text,
`css_id` int(11) default NULL,
`mod_f` varchar(20) default NULL,
`admin` varchar(20) default NULL,
PRIMARY KEY (`user_id`),
FULLTEXT KEY `full_index`
(`city`,`state`,`use
rname`,`email_addres
s`,`ip`)
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1;
Notice the FULLTEXT; I have the ip listed to be indexed. Using a PHP =
script I have it will not grab the IP that I am searching for, even =
though it *is* in the database. The ip's are entered into the database =
as 192.168.1.10. When I search for a username it works great.
Is it because of the "." (periods) in the search string??
Hopefully I explained that right this time!! :) LOL
--=20
Best regards,
~WILL~
Key: http://code-heads.com/keys/ch1.asc=20
Key: http://code-heads.com/keys/ch2.asc=20
Linux Commands: http://code-heads.com/commands=20
Linux Registered User: 406084 (http://counter.li.org/)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|