SQLite minor help
#1

I new to SQLite (SQL) started learning 3-4 days ago.
anyways, my question how to retrieve all the player's names from a specific IP
For example
i have this in the database
http://prntscr.com/bhvwe9

and i want to retrieve all the names of the players from the ip "127.0.0.1"

thanks in advance
regards,
turbo
Reply
#2

Код:
 SELECT `PlayerName` FROM `Users` WHERE `Player IP` = '127.0.0.1'
Код:
 SELECT `column1` FROM `tablename` WHERE `column2` = 'field'
correct me if im wrong
Reply
#3

I am sorry i dont know much about Sqlite but normal query would be like
PHP код:
SELECT 'Username' from Users WHERE IP '127.0.0.1' 
PS: ToiletDuck faster then me xD
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)