vB IP search

[Cloud Strife]

Normally it woks ok, it takes its time but it works. But now imtrying to find which user has a particular IP, and it just keepsprocessing for ages and then times out. I really need to knowwhich user has this IP so I can ban him. Is there a moreefficient way to do the search? Maybe a command in phpmyadmin?

[Zachery]

It would probaly take the same ammount of time in phpmyadmni.

[Cloud Strife]

I really need to find out the username from this IP.. Is there any other way for me to get it?

[Cloud Strife]

Maybe a query to download all usernames and ips to xml so I can search in microsoft excel?

[Steve Machol]

Try this query:

SELECT username FROM post WHERE ipaddress='xxx.xxx.xxx.xxx';

[Cloud Strife]

Thanks... Is there any way to search partial ips?

[Steve Machol]

Probably, but I don't know the query to do this.