sql where with or code example

Example 1: where clause in sql

Where clause basically returns only 
true conditions

Select First_Name
From Customers
Where ID = 1905Cimbom;

Example 2: sql where a or b

-- example
SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'