SQL Programming

A Wildcard character can be used to substitute for any other character(s) in a string.

Note: In SQL, wildcard characters are used with the SQL LIKE operator.

With SQL, the wildcards are:

SQL % Wildcard:

Example:

SELECT * FROM Customers
WHERE City LIKE 'anu%';

Note: SQL statement select all customers with a City starting with “anu”.

Output:

Example:

SELECT * FROM Customers
WHERE City LIKE '%pur%';

 Note: SQL statement select all customers with a City containing the pattern “pur”.

Output:

SQL _ Wildcard:

Example:

SELECT * FROM Customers
WHERE City LIKE '_aunpur';

Note: SQL statement select all customers with a City starting with any character, followed by “aunpur”.

Output:

SQL [charlist] Wildcard:

Example:

SELECT * FROM Customers
WHERE City LIKE '[jap]%';

 Note: SQL statement select all customers with a City starting with “j”, “a”, or “p”.

Output:

Example:

SELECT * FROM Customers
WHERE City LIKE '[j-l]%';

 Note: SQL statement select all customers with a City starting with “j”, “k”, or “l”.

Output:

Example:

SELECT * FROM Customers
WHERE City LIKE '[!jap]%';

OR

SELECT * FROM Customers
WHERE City NOT LIKE '[jap]%';

 Note: SQL statement select all customers with a City NOT starting with “j”, “a”, or “p”.

Output: