Page 1 of 1

SELECT DESTINCT(ip) FROM table_name

Posted: Tue Nov 26, 2002 12:37 pm
by phice
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?

Posted: Tue Nov 26, 2002 3:13 pm
by Rob the R
You have it right, for the most part:

Code: Select all

SELECT DISTINCT ip FROM table_name;
http://www.mysql.com/doc/en/Selecting_c ... tml#IDX400