Query:
SELECT AccountGroup FROM customers WHERE Accountgroup Like 'N4K - MI - TawasSchool%'

Result:
+------------------------+
| AccountGroup           |
+------------------------+
| N4K - MI - TawasSchool |
| N4K - MI - TawasSchool |
etc.....
| N4K - MI - TawasSchool |
| N4K - MI - TawasSchool |
+------------------------+
69 rows in set (0.00 sec)


Query:
SELECT distinct AccountGroup FROM customers WHERE Accountgroup Like 'N4K - MI - TawasSchool%'

Result:
Empty Set.

Query:
SELECT AccountGroup FROM customers WHERE Accountgroup Like 'N4K - MI - TawasSchool%' group by accountgroup

Result:
Empty Set.