How to use OR Operator..?

Select * from Table_name
Where column_name='value'
OR column_name=value
e.g
Select * from Technology where id=1 or name='manish'