I want to get data using vise versa column from database in mySql Database.

For example, see following image.
[![enter image description here](https://i.stack.imgur.com/7hwuj.png)](https://i.stack.imgur.com/7hwuj.png)

Above image you can see column name **initiator\_user\_id** & **friend\_user\_id** column , So I want all the those `friends_user_id and initiator_user_id` that are in stored in both column. So here `1` is stored in both column so i want 89,63,155 ids that are stored in both column.

I have tried to get record using **CASE** Statement but it'll not work.

SQL Query..

```
 SELECT *,
CASE
    WHEN friend_user_id != '' THEN initiator_user_id 
    WHEN initiator_user_id != '' THEN friend_user_id 
    ELSE ''
END AS users_id
FROM tablename

```

Someone please let me know , How could i get those records?