or condition in like sql code example
Example 1: sql where value like a or b
-- example
SELECT Id, ProductName, UnitPrice, Package
FROM Product
WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'
Example 2: what is like operator in sql
(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';