You are here
Home > Posts tagged "wildcards"

LIKE Operator in sql

LIKE Operator We can filter character string data based on pattern matching using LIKE operator. We can use LIKE operator in where clause of select, delete and update statement. Syntax: select column1, column2,….,columnN from table_name where column LIKE pattern; The wildcards used in LIKE patterns are:   Wildcard Meaning Example %(percent) Any string including an empty one ‘Kp%’