SQL Wildcards

SQL Wildcards are characters that are used to refine queries when searching for specific values in a table.

  • SQL Wildcards are different characters used to refine or filter SQL queries
  • SQL Wildcards are used with the LIKE operator
  • SQL Wildcards are added to SQL queries to perform complex searches

There are many SQL Wildcards and below you will find the ones mostly used

Wildcard Description
% SQL Wildcard for representing remaining characters which can range from zero to many characters
_ SQL Wildcard for representing a single character
[charlist] SQL Wildcard for representing a single character in charlist
[^charlist]or

[!charlist]

SQL Wildcard for representing a single character NOT in charlist

.