enter image description here

Counting the number of identical data in the mysql table

Closed due to the fact that the essence of the question is incomprehensible by the participants aleksandr barakin , default locale , andreymal , Edward , Viktorov Jan 12 '18 at 5:36 .

Try to write more detailed questions. To get an answer, explain what exactly you see the problem, how to reproduce it, what you want to get as a result, etc. Give an example that clearly demonstrates the problem. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • And the question is what? And where is php? - test123
  • Need to show how many clicks home, portal, bic - Yernar Makhambetkul
  • The question concerns only sql. Tried to watch the documentation? w3schools.com/sql/sql_distinct.asp Apply a similar request to the suggested answer from user190134. - test123
  • one
    одинаковых данных - what should be the same? - splash58
  • It is necessary to give an example of the data and result available in the table. From the description is unclear. - default locale

2 answers 2

Group by click field, add COUNT() stat:

 SELECT A.click , COUNT(*) count_click FROM table A GROUP BY A.click 
     SELECT count(*) FROM `table` WHERE `click` = 'bic';