0 votes
in SQLite by
What is the usage of LIKE operator with WHERE clause?

1 Answer

0 votes
by

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_'   

Related questions

0 votes
asked Nov 12, 2021 in SQLite by Robin
0 votes
asked Jan 3 in MariaDB by rajeshsharma
...