I have a table called relationships in my MySQL database which has the columns follower\_id and followed\_id. These represent followings on Instagram, for example if an account with ID 1 followed an account with ID 2 then a row would exist in my table where follower\_id was 1 and followed\_id was 2. 

What I want to do is be able to find accounts that follow both account with ID 1 AND account with ID 4 for example. I have tried creating temporary tables using SELECT statements like this:

```
CREATE TEMPORARY TABLE temp1 
SELECT follower_id FROM relationships 
WHERE followed_id = '1'

```

and

```
CREATE TEMPORARY TABLE temp2 
SELECT follower_id FROM relationships 
WHERE followed_id = '4'

```

and trying to cross reference the two temporary tables but this takes a very long time. Is there a quicker way to do this in MySQL?