[Stinged]

If you want to get a player's IP:

Код:

SELECT `IP` FROM `users` WHERE `Name` = '%e'

NOTE: Everything in red can be different (depending on your table)

If you want to get all the names that share a certain IP:

Код:

SELECT `Name` FROM `users` WHERE `IP` = '%s'