Question

What is the usage of LIKE operator with WHERE clause?

Answer 1

The LIKE operator is used to match text values against a pattern using wildcards. It uses two wildcards % and _ with string for matching with input.

Syntax:

SELECT FROM table_name    

WHERE column LIKE 'XXXX%'   

SELECT FROM table_name    

WHERE column LIKE 'XXXX_'