mysql distinct etc
mysql distinct etc
Out of context: Reply #4
- Started
- Last post
- 4 Responses
- mikotondria30
Thats awesome, thanks acescence, I owe you one :).
ended up as:SELECT *, COUNT(title) FROM my_table WHERE status='active' AND title REGEXP '^s' GROUP BY title HAVING COUNT(title)>=1 ORDER BY title ASC