Trying to learn something about a MYSQL database. If I have a field of entries, named x. I want a list of unique entires in x. (ie a list of every possible answer in x) what SQL query do I write to output that?
by 
Ephraim
ANSWERS: 1
-
Try using a GROUP BY clause. select * FROM x WHERE y GROUP BY z This should group all terms that are the same. Or you could use SELECT DISTINCT x FROM y; http://dev.mysql.com/doc/refman/5.1/en/select.html
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC