Embedded Files
1 The MySQL LIKE Operator
1 The MySQL LIKE Operator
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
There are two wildcards often used in conjunction with the LIKE operator:
The percent sign (%) represents zero, one, or multiple characters
The underscore sign (_) represents one, single character
3. Reference: https://www.w3schools.com/mysql/mysql_like.asp
2. LIKE Syntax
2. LIKE Syntax
2.1 Like Query
SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;
2.2 Here are some examples showing different LIKE operators with '%' and '_' wildcards:
Page updated
Google Sites
Report abuse