Logging

Question

Good afternoon everyone, I have the following table:

I have the following select:

"SELECT DISTINCT `ip` FROM `visualizacoes` WHERE MONTH(data) = MONTH(NOW()) AND id_usuario = :id_usuario"

Use the distinct to returns only one record per ip, but would like to return an ip record per news.

EX: if a particular ip views the post 1, and then views the post 2 I want to return the two record.

But if it views the post 1 twice I want it to return only one record

PS: Ignore the existence of two columns on date.

Answer 1

As @rray already quoted in the comments, use GROUP BY.

SELECT ip, id_noticia
  FROM visualizacoes
 WHERE MONTH(data) = MONTH(NOW()) 
   AND id_usuario = :id_usuario
 GROUP BY ip, id_noticia;

With GROUP BY you can use aggregation functions. For example, if you want to count how many times each IP visited a particular news item, use the function COUNT:

SELECT ip, id_noticia, COUNT(*) AS visitas
  FROM visualizacoes
 WHERE MONTH(data) = MONTH(NOW()) 
   AND id_usuario = :id_usuario
 GROUP BY ip, id_noticia;