SQL Match table and multiple columns

I wanted to know a Query where in which i want to locate a specific table that contains two or more columns:

I tried:

SELECT * 
FROM DB 
WHERE TableName = 'TableName' 
AND ColumName in('column1' , 'column2') 

But this query will look if any of those columns are there, but i want it to return only if all of them are a match.

I hope this questions makes sense.

from Recent Questions - Stack Overflow https://ift.tt/SqLRQ3l
https://ift.tt/ln6XjYu