distinct

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Citizen99
Forum Commoner
Posts: 32
Joined: Wed Dec 24, 2003 6:52 am
Location: Where noone understand me...

distinct

Post by Citizen99 »

I have column with 30.000 records and i want to get of repeated records..

SELECT DISTINC column FROM table

doesnt work ? 1054 - Unknown column 'DISTINC' in 'field list'...
Last edited by Citizen99 on Sat Feb 21, 2004 11:57 am, edited 2 times in total.
evilMind
Forum Contributor
Posts: 145
Joined: Fri Sep 19, 2003 10:09 am
Location: Earth

Post by evilMind »

You are spelling it like: DISTINCT right?
[mysql_man]DISTINCT[/mysql_man]
Citizen99
Forum Commoner
Posts: 32
Joined: Wed Dec 24, 2003 6:52 am
Location: Where noone understand me...

Post by Citizen99 »

Now I know what is wrong... everything works fine. THX
Post Reply