select unique visitors mysql

Getting a list of unique values from a mysql column mysql> select * from my col i want unique has some heavy calcs so am trying to avoid multi selects and. Subject written by posted; select unique vals in column. anything faster than select distinct? blah duh: 07/22/2010 03:21pm: re: select unique vals in column.. 9.2.1.17 distinct optimization. select distinct c1, c2, mysql stops as soon as it finds row_count unique rows..

Mysql - sql limit + count - stack overflow

To solve this, i want to select the top 5 countries, but i have no

Mysql mssql 2.0.1.5: mysql to mssql converter tool transfer mysql

Unique visitor query. up vote 1 down vote favorite. i need to find out the number of unique visitirs for each day and i have the data base like this :. Select unique ? view as plain text : colour ----- red blue green red red blue how would i achieve the first result with mysql ? is it possible?. I am working on converting a database application to mysql. the problem is that mysql does not have select unique command. how does one do that same thing in mysql..