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.

Community · Accepted Answer · 2017-05-23 12:20:05Z

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, 2017 at 12:20

CommunityBot

11 silver badge

answered Jul 8, 2012 at 15:22

chrisbulmer

1,2458 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Simon Forsberg · Accepted Answer · 2012-07-08 15:20:29Z

0

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

SELECT post_title, content
FROM post
GROUP BY post_title, content

answered Jul 8, 2012 at 15:20

Simon Forsberg

13.4k11 gold badges67 silver badges109 bronze badges

1 Comment

FlyingCat Over a year ago

it won't show all the duplicated title and contents. thanks though

Tudor Constantin · Accepted Answer · 2012-07-08 15:21:59Z

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 8, 2012 at 15:21

Tudor Constantin

26.9k7 gold badges54 silver badges73 bronze badges

2 Comments

Tudor Constantin Over a year ago

why not? what is this query returning, and what do you need?

FlyingCat Over a year ago

your query select id instead of title. plz see the accepted answer. :)

Collectives™ on Stack Overflow

Simple mysql select issue

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related