Simple mysql select issue

Question

I am trying to select all the duplicated row in my database. I have table below:

title     content
aa          hahaha
bb          weeeee
cc          dddddd
aa          ggggg
aa          ggggggee
dd          hhhhhhh
bb          ggggggg

my query is

select count(post_title) as total, content from post group by post_title

it will only show

 total        content
    3        hahaha
    2        weeeeee

but i want to show something like

total        content
aa          hahaha
aa          ggggg
aa          ggggggee
bb          weeeeeee
bb          geeeeeee

not sure what to do and I think it might be simple. Thanks for the help.

score 6 · Accepted Answer · edited May 23 '17 at 12:20

6

Select title, content
From table_name
Where title In
    (Select title From Table
     Group By title
     Having COUNT(*) > 1)

(from Multiple NOT distinct)

edited May 23 '17 at 12:20

Community

1
1

answered Jul 08 '12 at 15:22

chrisbulmer

1,237
8
15

score 0 · Answer 2 · answered Jul 08 '12 at 15:20

0

From what I understand, the SQL query should look like:

SELECT post_title, content
FROM post
GROUP BY post_title, content

answered Jul 08 '12 at 15:20

Simon Forsberg

13,086
10
64
108

it won't show all the duplicated title and contents. thanks though – FlyingCat Jul 08 '12 at 15:27

score 0 · Answer 3 · answered Jul 08 '12 at 15:21

0

try with something like

SELECT total, content FROM post 
   WHERE id IN ( 
    SELECT id FROM post 
         GROUP BY post_title 
         HAVING count(post_title) > 1 
   )

answered Jul 08 '12 at 15:21

Tudor Constantin

26,330
7
49
72

why not? what is this query returning, and what do you need? – Tudor Constantin Jul 08 '12 at 15:35
your query select id instead of title. plz see the accepted answer. :) – FlyingCat Jul 08 '12 at 15:56

Simple mysql select issue

3 Answers3