Q:

MySQL Looking for multiple IDs

I'm trying to make a News Feed and I'm stuck. 
Let's say I have this MySQL table with some data called table friends:
and let's say I have this for statuses called table status
And for example, my user id corrolates with friend_1 or friend_2 on friends and uid for status. What MySQL query would I need to use to be able to see which friends I have from friends that have rows of data in status?

A:

SELECT status.*
FROM status, friends
WHERE (friend_2 = uid AND friend_1 = <your_id>) 
OR (friend_1 = uid AND friend_2 = <your_id>);

In case on eevery friendship insert 2 rows ( and ) - you don't need the OR (...)

