| CodeHeads 2006-02-25, 9:43 am |
| --=- NErndXcerCrQjkCnXY5C
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
On Thu, 2006-02-23 at 22:04 -0500, Mathieu Bruneau wrote:
> Ok I got 2 informations for you:
>=20
> 1) IPv4 address are actually 32 bit integer, easily store in 32 bits
> fast search etc etc etc (You can google for more on this storage
> format). Normally you could find a way to goes from the string
> 192.168.1.1 to the equivalent int. Look for ip2long() function in PHP
> for example!
>=20
> 2) FULLTEXT indexes are a special type of index in MySQL, their use on
> numeric field doesn't make sense. To be used on ip string they would
> require some tweaking as they normally don't remember word under 3
> letters if i'm correct. And last but not least they aren't use with a
> "like" but with a "match"
>=20
> You could however use an typical index here, or even better an unique
> index to ensure the validation!
>=20
> Hope it helps you in you development!
>=20
> See for all information about fulltext index in the manual
> http://dev.mysql.com/doc/refman/4.1...ext-search.html
Thanks for the reply :) Yes I was figured that was the problem but I
wanted to make sure that was it.
I did get it working like Ariel suggested. (where ip=3D'192.168.1.1') That
worked. I just did a separate search for the IP's.
Thanks again for all your help.
--=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/)
--=- NErndXcerCrQjkCnXY5C
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (GNU/Linux)
iD8DBQBD/ oLUfw3TK8jhZrsRAnnsA
KC6esgMHcqdM58C1zlbP
BPju7GagQCffPOc
aFtUTjxANisEFNiN51u/P2Y=
=FjFF
-----END PGP SIGNATURE-----
--=- NErndXcerCrQjkCnXY5C
--
|