i want to count and display each duplicate value in a column from the below table using php mysql
name
AAA
BBB
BBB
BBB
AAA
CCC
result should be like below
AAA-2
BBB-3
CCC-1
-
can i give you sql query.?Mehul Jariwala– Mehul Jariwala2017-10-13 04:52:38 +00:00Commented Oct 13, 2017 at 4:52
-
you need sql query.?Mehul Jariwala– Mehul Jariwala2017-10-13 04:53:13 +00:00Commented Oct 13, 2017 at 4:53
-
Ccc is not duplicatedStrawberry– Strawberry2017-10-13 06:10:14 +00:00Commented Oct 13, 2017 at 6:10
Add a comment
|
5 Answers
You need :
select name,count(1) from yourtable group by name
If you need output with hyphen (-)
select concat(name,'-',count(1)) from yourtable group by name
Comments
select name, count(name) as count from table_name group by name
1 Comment
Robin Daugherty
You can improve this answer by providing an explanation rather than just a bit of code.
try this,
select name, count(*) from <table> group by name;
Comments
SELECT name, COUNT(name) c_name FROM tablename GROUP BY name HAVING c_name>1
1 Comment
Robin Daugherty
Because of the HAVING clause, this does not provide the correct result.
<?php
require_once('connection.php');
$result=mysqli_query($conn,
"SELECT colum_name, concat(count(1),'-',colum_name)
as colum_name
FROM table_name
group by colum_name
order by colum_name desc");
while ( $data=mysqli_fetch_assoc($result)) {
echo $data['colum_name']."<br>";
}
1 Comment
Arnold H
Am assumig you want to display data using php from the database. That will give you result: AAA-2 BBB-3 CCC-1 ( with your column name and table name respectively).