Python Dataframe - Selecting specific rows based on some columns

Comparing Pandas dataframes with SQL dataset, I need to create a sub dataset from the original dataset by comparing values of some columns from the pandas dataframes. Something similar to standard DDL query as below:

SELECT * 
	FROM TABLENAME
	WHERE COLUMNNAME = VALUE