mysql select where column value is the same (unknown value)

Question

I need to create a MySQL query which searches for values, but I need the results to return which have the same content_id number (which is unknown until searched for).

Here's my table:

content_id      item_id         tag_id
1               4               2
1               4               3
1               4               4
1               4               5
2               5               7
2               5               8
3               6               8
3               6               9

And currently here's my query:

SELECT item_id FROM table WHERE tag_id IN (7,8)

This is returning:

Array
(
    [0] => stdClass Object
        (
            [item_id] => 5
        )

    [1] => stdClass Object
        (
            [item_id] => 5
        )

    [2] => stdClass Object
        (
            [item_id] => 6
        )

)

But I need it to return (because of content_id = 2 in this instance):

Array
(
    [0] => stdClass Object
        (
            [item_id] => 5
        )

)

I hope this makes sense..

then just add an and clause and group

Kevin
– Kevin

2016-11-30 01:27:03 +00:00
Commented Nov 30, 2016 at 1:27 — Kevin
– Kevin, Commented Nov 30, 2016 at 1:27

Duc Filan · Accepted Answer · 2016-11-30 01:31:24Z

2

You need to gather the content_id into groups, then check which group has count more than 1.

SELECT item_id FROM table group by content_id having count(content_id) > 1

answered Nov 30, 2016 at 1:31

Duc Filan

7,2073 gold badges24 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

mysql select where column value is the same (unknown value)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related