like trong sql code example
Example 1: like sql
WHERE CustomerName LIKE 'a%'
WHERE CustomerName LIKE '%a'
WHERE CustomerName LIKE '%or%'
WHERE CustomerName LIKE '_r%'
WHERE CustomerName LIKE 'a__%'
WHERE ContactName LIKE 'a%o'
Example 2: sql where value like a or b
SELECT Id, ProductName, UnitPrice, Package
FROM Product
WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'
Example 3: like sql
syntax => SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern
the pattern.
SELECT * FROM Persons
WHERE City LIKE 's%'