This article is part of my SQL-Tutorial
Motivation
Sometimes you need to retrieve data from a database without knowing the exact string to look up
so wildcards for the rescue
Underscore
Se_en
represents a pattern with a wildcard character.
The _
means you can substitute any individual character here without breaking the pattern.
It matches exactly one character.
The names Seven
and Se7en
both match this pattern.
Percentage sign
The percentage sign %
is another wildcard character that can be used with LIKE
.
It matches one or more characters