On Thu, 2006-02-23 at 22:04 -0500, Mathieu Bruneau wrote: > Ok I got 2 informations for you: > > 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! > > 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" > > You could however use an typical index here, or even better an unique > index to ensure the validation! > > Hope it helps you in you development! > > See for all information about fulltext index in the manual > http://dev.mysql.com/doc/refman/4.1/en/fulltext-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='192.168.1.1') That worked. I just did a separate search for the IP's. Thanks again for all your help. -- Best regards, ~WILL~ Key: http://code-heads.com/keys/ch1.asc Key: http://code-heads.com/keys/ch2.asc Linux Commands: http://code-heads.com/commands Linux Registered User: 406084 (http://counter.li.org/)
signature.asc
Description: This is a digitally signed message part