In this article, SQL Wildcard, They are used just as LIKE operator, and also WHERE clause to search for a mere option in a column, The wildcard in SQL is used in a string to substitute characters.
Wildcard are two types:
1. Underscore (_)--> This wildcard is used to match the character.
2. Percent sign (%) --> This wildcard is used for matches in one or more characters.
Syntax
SELECT FROM table_name
WHERE column LIKE 'AAAA%'SELECT FROM table_name
WHERE column LIKE '%AAAA%'or
SELECT FROM table_name
WHERE column LIKE 'AAAA_'or
SELECT FROM table_name
WHERE column LIKE '_AAAA'or
SELECT FROM table_name
WHERE column LIKE '_AAAA_'Example:
SELECT * FROM CUSTOMER
WHERE SALARY LIKE '2200%'SELECT * FROM Customer
WHERE City LIKE 'de%'SELECT * FROM Customer
WHERE City LIKE '%ee%'SELECT * FROM Customer
WHERE City LIKE '_del'
2020-04-26