-
SQL – Like Operator
SQL – Like Operator Table Of Contents: What Is SQL Like Operator? Syntax Of SQL Like Operators. Examples Of Like Operators. (1) What Is SQL 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 Note: MS Access uses an asterisk (*) instead of the percentage sign (%), and a question mark (?) instead of the underscore (_). (2) Syntax Of SQL Like Operator. Syntax: SELECT