Filter
Top Products
[Figure: Example of specifying the EXISTS predicate]
6.2.4 Checking whether values match a character-string pattern
Use the LIKE predicate to check whether data in a character-string type or national-language character-string type
matches a certain character-string pattern. The result of the LIKE predicate is true if the specified pattern is contained
in a column. The result is false if the pattern is not contained in any column. The result is undefined if the specified
columns or pattern have a null value. Data in character-string or national-language character-string type, and blank
characters in a pattern are treated as a single alphabetic or national-language character.
If the string or pattern specified in the LIKE predicate is a variable-length character string, data within the valid range is
evaluated. The following is an example of specifying the LIKE predicate:
Example 1:
In this example, rows where "JAPAN" appears in the ADDRESS column of the COMPANY table are
specified. Figure: Using the LIKE predicate to specify rows shows the result of this specification.
100