I've seen something like that somewhere, but I forgot how to do it.
What it does is selects everthing from the table, listing only different values of the columb "ip". Anyone know what the query line for this is?
SELECT DESTINCT(ip) FROM table_name
Moderator: General Moderators
You have it right, for the most part:
http://www.mysql.com/doc/en/Selecting_c ... tml#IDX400
Code: Select all
SELECT DISTINCT ip FROM table_name;