TalkPHP - View Single Post

xenon · 08-20-2008, 05:43 PM

I think he wants to select only the distinct words. In which case, this query would work perfectly:

Code:

SELECT DISTINCT(word) FROM table_name GROUP BY word

...assuming that you have each word on its own row.

08-20-2008, 05:43 PM	#7 (permalink)
xenon The Frequenter Join Date: Dec 2007 Location: Bucharest, Romania Posts: 438 Thanks: 3	I think he wants to select only the distinct words. In which case, this query would work perfectly: Code: SELECT DISTINCT(word) FROM table_name GROUP BY word ...assuming that you have each word on its own row. __________________ I have optimistic thoughts, even though sometimes (if not always) life's a bitch.