How can I select unique row based on value matched in other column : I have searched a lot but can not get my head around this.

I need to filter the results based on comparing values in 2 rows.

Data)
[Data I want to filter][1]

Results I want to end up with
[Desired results][2]

Is this possible in MySQL?
If there is a way to do this in PHP after the query I'm happy with that too.
Thanks for any help. 


  [1]: https://i.stack.imgur.com/bEKfz.png  [2]: https://i.stack.imgur.com/35CMY.png