Editing Glob (programming) (section)

===SQL===
The [[SQL]] {{code|LIKE}} operator has an equivalent to {{code|?}} and {{code|*}} but not {{code|[…]}}.

{| class="wikitable"
|-
! Common wildcard
! SQL wildcard
! Description

|-
| {{code|?}}
| {{code|_}}
| matches any single character

|-
| {{code|*}}
| {{code|%}}
| matches any number of any characters including none

|}

Standard SQL uses a glob-like syntax for simple string matching in its <code>LIKE</code> operator, although the term "glob" is not generally used in the SQL community. The percent sign ({{code|%}}) matches zero or more characters and the underscore ({{code|_}}) matches exactly one.

Many implementations of SQL have extended the <code>LIKE</code> operator to allow a richer pattern-matching language, incorporating character ranges ({{code|[…]}}), their negation, and elements of regular expressions.<ref name="transact-sql-like"/>