How can I get an item out of a data table by value?

How can I get an item out of a data table by value using blueprints?
I have a data table that looks like this:

233354-screenshot-1.png

I want to be able to get PetOpposite value by Pet and not by row name.
If this was SQL, I would do something like this:
Select PetOpposite
From DataTable
Where Pet = ‘Snake’

I would want the ‘Mongoose’ to return.

Thanks in advance!

to my knowledge it cant be done directly in blueprints. i imagine this is because when getting data from a data table it can only return one row and the table could have many rows with the same values so it would never work correctly. im sure you could probably have some sort of work around using loops or something.