In this article, we will learn how to use the LIKE operator with a SQL select query.
To search for a specified pattern in the column, The LIKE operator is used in a WHERE clause.
Usually, there are two wildcards used in conjunction with the LIKE operator:
The % (Percent) and the _ (Underscore) can also be used in combinations.
Syntax
SELECT column_name(s) FROM TABLE_NAME WHERE columnN LIKE pattern;
Example-1
The subsequent statement would return all articles with a Title starting with “I”.
SELECT * FROM Article WHERE Title LIKE 'I%';
Example-2
The subsequent statement would return all articles with a Title NOT starting with “I”.
SELECT * FROM Article WHERE Title NOT LIKE 'I%';
Example-3
The subsequent statement would return all articles with a Title that have “t” in the third position.
SELECT * FROM Article WHERE Title LIKE '__t%';
Also, check How To Use TOP Clause In SQL
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular