Like
The LIKE operator is used for finding specific patterns in the columns. Both the percent sign (%) and the underscore sign (_) might act as wildcards, with the first one representing zero, one, or multiple characters, and the latter one representing exclusively one character. These two signs can also be used in combinations.
If we’d like to return only those rows where the order, we’d write the following query:
TEXT/X-SQL
1SELECT *
2FROM Person
3WHERE OrderCode LIKE ‘11%’;The resulting table would look like this:
In the table below, we show some examples of how LIKE can be used with ‘%’ and ‘_’ wildcards:
