'SQL SELECT DISTINCT Not functioning

I have a selector where I wish users to only see distinct 'items' from a table. Below I have code to loop through the results. If I change the query to SELECT * it works perfectly fine.

SELECT DISTINCT set FROM trail ORDER BY category

Is DESTINCT depreciated? I can't figure out why it wouldn't work.

I have come here after checking other peoples questions regarding this topic. I Tried adding two columns and that displayed nothing as well.

mysqlsql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions