I'm trying to parse some server logs from a MySQL database, and count the type of domains which they came from ( .com, .net, .org, etc..) Does anyone know of how to do this in one query instead of multiple querys for each domain type?