How to use AND Operator..?

Select * from Table_name
Where Column_name='value'
AND Column_name='value'
e.g
Select * from Technology Where id=1 and name='manish'