mysql distinct etc
mysql distinct etc
Out of context: Reply #3
- Started
- Last post
- 4 Responses
- acescence0
oh, sorry misunderstood. that will give you all rows with unique combos, not unique on just that one field. that's a little more tricky...
SELECT *, COUNT(name) FROM my_table GROUP BY name HAVING COUNT(name)>=1;