like with and condition in sql code example

Example 1: like operator in sql

(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';

Example 2: sql where value like a or b

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

Tags:

Sql Example

Related