Wildcard

In computing, a wildcard refers to a character that can be substituted for zero or more characters in a string. Wildcards are commonly used in computer programming, database SQL search queries, and when navigating through DOS or Unix directories via the command prompt.

Below are some popular uses for wildcards:

  • Regular Expressions - A period (.) matches a single character, while .* matches zero or more characters and .+ matches one or more characters.
    ▶ Example: $pattern = "Mac(.*)"
  • SQL Queries - A percent symbol (%) matches zero or more characters, while an underscore (_) matches a single character.
    ▶ Example: SELECT * FROM Computers WHERE Platform LIKE 'Mac%'
  • Directory Navigation - An asterisk (*) matches zero or more characters, while a question mark (?) matches a single character.
    ▶ Example: dir *.exe

In the examples above, wildcards are used to search for partial matches instead of exact matches. This can be helpful when searching for files or looking up information from a database.

Updated May 26, 2010 by Per C.

quizTest Your Knowledge

What is communication in which data can only be transmitted one way called?

A
Soloplex
0%
B
Uniplex
0%
C
Simplex
0%
D
Duplex
0%
Correct! Incorrect!     View the Simplex definition.
More Quizzes →

The Tech Terms Computer Dictionary

The definition of Wildcard on this page is an original definition written by the TechTerms.com team. If you would like to reference this page or cite this definition, please use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about this definition or would like to suggest a new technical term, please contact us.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.