dimanche 4 septembre 2016

Selecting all messages from individual ips that has 20 or more messages

I'm trying to select all the messages from individual ips that has 20 or more messages, but I'm having trouble selecting it. Here's my query:

SELECT messages
FROM currentChat
HAVING count(id) >= 20
GROUP by ip

Aucun commentaire:

Enregistrer un commentaire