using exists against entire column?

[Stephen Madison]

I originally wanted to write a select statement that would only pull data if a db element existed in a local directory as a filename. I found this was not an option so I wrote a perl script to store the directory contents into an array and then push the array elements into a new column of the db I am trying to query. All I need to do now is write my select statement to pull rows if the value of column_b exits in my new column that was built by the directory contents array.
This is easy if I was trying to compare the column values while staying on a single row but my issue is that I need to compare the single row value for column_b against ANY row value of column_d

Is this possible?