LIKE() FUNCTION The MySQL LIKE function is used to check for pattern matching.
Syntax:
string LIKE pattern;
Parameters: string: It is used to specify the string to evaluate. pattern: It is used to specify the pattern to match.
Example 1:
mysql> SELECT ‘abc’ LIKE ‘ABC’;
Output:
1
Explanation: The LIKE function returns 1 for a successful pattern matching.
Example 2:
mysql> SELECT ‘abc’ LIKE ‘ ABC ’;
Output:
0
Explanation: The LIKE function returns 0 for an unsuccessful pattern matching.
