Home : Technical Terms : Wildcard Definition


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

Cite this definition:


TechTerms - The Tech Terms Computer Dictionary

This page contains a technical definition of Wildcard. It explains in computing terminology what Wildcard means and is one of many technical terms in the TechTerms dictionary.

All definitions on the TechTerms website are written to be technically accurate but also easy to understand. If you find this Wildcard definition to be helpful, you can reference it using the citation links above. If you think a term should be updated or added to the TechTerms dictionary, please email TechTerms!

Subscribe to the TechTerms Newsletter to get featured terms and quizzes right in your inbox. You can choose to receive either a daily or weekly email.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe at any time.
Questions? Please contact us.