Show Menu

Wildcards Cheat Sheet (DRAFT) by

Wildcards in Linux, SQL

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Wildcards in Linux

matches one or more occurr­ences of any character, including no character.
$ rm tar
represents or matches a single occurrence of any character.
$ ls l?
matches any occurrence of character enclosed in the square brackets. It is possible to use different types of characters (alpha­numeric charac­ters): numbers, letters, other special characters etc.
$ ls users-­[0-­9][­a-z­0-9­][0-9]*
negate a set of charac­ters.
$ ls users-­[0-­9][­!0-­9][­a-z­A-Z]*
Represents a range of characters
$ ls users-­[0-­9][­!0-­9][­a-z­A-Z]*

Wildcards in SQL

Represents zero or more characters
bl% finds bl, black, blue, and blob
Represents a single character.
h_t finds hot, hat, and hit
Represents any single character within the brackets.
h[oa]t finds hot and hat, but not hit
Represents any character not in the brackets
h[^oa]t finds hit, but not hot and hat
Represents a range of characters
c[a-b]t finds cat and cbt