---
description: Wildcards are characters that help search data matching complex criteria. Wildcards are used in conjunction with the comparison operator LIKE, NOT LIKE,% percent , _ underscore.
title: "MySQL Wildcards: Like, NOT Like, Escape, ( % ), ( _ )"
image: https://www.guru99.com/images/mysql-wildcards.png
---

[Skip to content](#main)

**⚡ Smart Summary**

MySQL Wildcards make pattern-based searching possible by pairing the LIKE and NOT LIKE operators with special characters. This explains the percentage and underscore wildcards, the ESCAPE keyword, practical queries against the myflixdb database, and performance considerations.

- 🔍 **Core Definition:** Wildcards are placeholder characters that LIKE and NOT LIKE use to match text patterns instead of exact values.
- 📊 **Percentage Wildcard:** The % symbol matches zero or more characters, so ‘%code%’ returns every movie title that contains the word code.
- 🔡 **Underscore Wildcard:** The \_ symbol matches exactly one character, so ‘200\_’ returns titles released between 2000 and 2009.
- 🚫 **Negation Rule:** NOT LIKE inverts the comparison and returns every row that fails the specified pattern.
- 🛡️ **Escape Handling:** The ESCAPE keyword marks a literal % or \_ inside the search string so that it is treated as data.
- ⚡ **Performance Insight:** A leading % blocks index usage and forces a full table scan, so anchor patterns on the left whenever possible.
- 🧩 **Method Selection:** LIKE covers simple prefix and suffix matching, while REGEXP handles character classes and alternation.

Read More

![](https://www.guru99.com/images/mysql-wildcards.png)

## What are MySQL Wildcards?

**MySQL Wildcards** are special characters that help you search for data matching a complex pattern instead of an exact value. Wildcards are always used in conjunction with the LIKE comparison operator or with the NOT LIKE comparison operator.

MySQL supports two wildcard characters, and each one answers a different question about your data.

| Wildcard | Meaning | Example pattern | Matches |
| --- | --- | --- | --- |
| % | Zero (0) or more characters | ‘%code%’ | Code Name Black, Davinci Code |
| \_ | Exactly one character | ‘200\_’ | 2005, 2008 |

Now that the two characters are defined, the next section explains why they are worth learning.

## Why use Wildcards in MySQL?

If you are familiar with SQL, you may think that you can already search for any complex data using SELECT and the WHERE clause. So why use wildcards at all?

Before we answer that question, let us look at an example. Suppose that the marketing department of the Myflix video library carried out promotions in the city of Texas and would like feedback on the number of members that registered from Texas. You can use the following SELECT statement together with the WHERE clause to get the desired information.

```
SELECT * FROM members
WHERE postal_address = 'Austin, TX'
   OR postal_address = 'Dallas, TX'
   OR postal_address = 'Iola, TX'
   OR postal_address = 'Houston, TX';
```

As you can see from the above query, the “ [WHERE clause](https://www.guru99.com/where-clause.html)” becomes long and fragile: every new city has to be added by hand, and a single misspelled address is silently excluded. Using wildcards simplifies the query, because a single pattern covers every city in the state.

```
SELECT * FROM members
WHERE postal_address LIKE '%TX';
```

In short, wildcards allow you to build powerful search features into data-driven applications with far less SQL. The next section breaks down each wildcard character in turn.

## Types of MySQL Wildcards

### % – The percentage wildcard

The percentage (%) character is used to specify a pattern of **zero (0) or more characters**. It has the following basic syntax.

```
SELECT * FROM table_name
WHERE fieldname LIKE 'xxx%';
```

**HERE:**

- “ [SELECT statement](https://www.guru99.com/select-statement.html)” is the standard SQL SELECT command.
- “WHERE” is the keyword used to apply the filter.
- “LIKE” is the comparison operator that is used in conjunction with wildcards.
- ‘xxx’ is any specified pattern, such as a single character or more, and “%” matches any number of characters starting from zero (0).

To fully appreciate the above statement, let us look at a practical example. Suppose we want to get all the movies that have the word “code” as part of the title. We would use the percentage wildcard on both sides of the word “code” to perform a pattern match anywhere in the title.

```
SELECT * FROM movies
WHERE title LIKE '%code%';
```

**Don't Miss:**

- [MySQL Views: How to Create View from Tables](https://www.guru99.com/views.html)
- [MySQL GROUP BY and HAVING Clause with Examples](https://www.guru99.com/group-by.html)
- [What is Database? Definition & Types](https://www.guru99.com/introduction-to-database-sql.html)
- [MySQL SELECT Statement with Examples](https://www.guru99.com/select-statement.html)

Executing the above script in [MySQL Workbench](https://www.guru99.com/introduction-to-mysql-workbench.html) against the myflixdb database gives us the results shown below.

| movie\_id | title | director | year\_released | category\_id |
| --- | --- | --- | --- | --- |
| 4 | Code Name Black | Edgar Jimz | 2010 | NULL |
| 7 | Davinci Code | NULL | NULL | 6 |

Notice that the search keyword “code” is returned whether it appears at the beginning or at the end of the title. This is because the pattern allows any number of characters before “code” and any number of characters after it.

Let us now modify the script so that the percentage wildcard appears at the beginning of the search criteria only.

```
SELECT * FROM movies
WHERE title LIKE '%code';
```

Executing the above script in MySQL Workbench against the myflixdb database gives us the results shown below.

| movie\_id | title | director | year\_released | category\_id |
| --- | --- | --- | --- | --- |
| 7 | Davinci Code | NULL | NULL | 6 |

Notice that only one record has been returned. The pattern matches any number of characters at the beginning of the title but requires the title to *end* with “code”.

Let us now shift the percentage wildcard to the end of the pattern instead. The modified script is shown below.

```
SELECT * FROM movies
WHERE title LIKE 'code%';
```

Executing the above script in MySQL Workbench against the myflixdb database gives us the results shown below.

| movie\_id | title | director | year\_released | category\_id |
| --- | --- | --- | --- | --- |
| 4 | Code Name Black | Edgar Jimz | 2010 | NULL |

Only one record is returned again, because this pattern matches every title that *starts* with “code” followed by any number of characters. The position of the % symbol therefore decides the meaning of the search.

**💡 Tip:** A pattern such as ‘code%’ can still use an index on the title column, while ‘%code%’ cannot. A leading percentage wildcard forces MySQL to scan every row, so keep the wildcard on the right whenever the search allows it.

### \_ – The underscore wildcard

The underscore wildcard is used to **match exactly one character**. Suppose that we want to find all the movies released in the years 200x, where x is exactly one character that could be any value. The script below selects all the movies released in the year “200x”.

```
SELECT * FROM movies
WHERE year_released LIKE '200_';
```

Executing the above script in MySQL Workbench against the myflixdb database gives us the results shown below.

| movie\_id | title | director | year\_released | category\_id |
| --- | --- | --- | --- | --- |
| 2 | Forgetting Sarah Marshal | Nicholas Stoller | 2008 | 2 |
| 9 | Honey mooners | Jhon Shultz | 2005 | 8 |

Notice that only movies whose year\_released value is 200 followed by any single character are returned. Unlike the percentage wildcard, the underscore reserves a place for one character and no more.

### NOT LIKE with wildcards

The NOT logical operator can be used together with wildcards to return the rows that do **not** match the specified pattern.

Suppose we want the movies that were not released in the years 200x. We combine the NOT logical operator with the underscore wildcard, as shown below.

```
SELECT * FROM movies
WHERE year_released NOT LIKE '200_';
```

| movie\_id | title | director | year\_released | category\_id |
| --- | --- | --- | --- | --- |
| 1 | Pirates of the Caribean 4 | Rob Marshall | 2011 | 1 |
| 4 | Code Name Black | Edgar Jimz | 2010 | NULL |
| 8 | Underworld-Awakeninh | Michahel Eal | 2012 | 6 |

Only the movies that do not follow the 200x pattern are returned, because NOT inverts the result of the wildcard comparison. Note that rows holding a [NULL](https://www.guru99.com/null.html) value are never returned by LIKE or NOT LIKE, since NULL is unknown rather than unequal.

### ESCAPE keyword

The ESCAPE keyword is used to **escape pattern-matching characters** such as the percentage (%) and the underscore (\_) when they form part of the data itself.

Suppose that we want to search for the literal string “67%”. We declare an escape character and place it immediately before the character that must be read as data.

```
LIKE '67#%%' ESCAPE '#';
```

If we want to find the movie “67% Guilty”, we can use the script shown below.

```
SELECT * FROM movies
WHERE title LIKE '67#%%' ESCAPE '#';
```

Note the double “%%” in the LIKE clause. The first one is preceded by the escape character (#) and is therefore treated as part of the string being searched for. The second one keeps its wildcard meaning and matches any number of characters that follow.

Any character can serve as the escape character, so the same query also works with the equals sign.

```
SELECT * FROM movies
WHERE title LIKE '67=%%' ESCAPE '=';
```

Wildcards cover simple patterns very well, but some searches need more expressive rules. The comparison below shows where the limit lies.

## MySQL Wildcards vs REGEXP: which one should you use?

MySQL supports only two wildcard characters. Character lists such as \[a-c], which some other database engines accept inside LIKE, are not supported. When a search needs character ranges, alternation, or anchoring, the [REGEXP operator](https://www.guru99.com/regular-expressions.html) is the correct choice.

| Criterion | LIKE with wildcards | REGEXP |
| --- | --- | --- |
| Pattern power | Two symbols only: % and \_ | Character classes, ranges, alternation, repetition |
| Typical use | Prefix, suffix, or “contains” searches | Validation, complex matching, multiple alternatives |
| Index usage | Possible when the pattern does not begin with % | Never uses an index |
| Readability | Simple for beginners | Steeper learning curve |

As a rule, reach for LIKE first: it is easier to read, and it is the only one of the two that can benefit from an index. Move to REGEXP when a single pattern must express several alternatives, for example matching every title that begins with a digit. Both operators are read-only comparisons, so neither one changes the rows returned by [INSERT](https://www.guru99.com/insert-into.html) or [UPDATE](https://www.guru99.com/sql-update-query.html) statements; they only filter what the WHERE clause selects.

## FAQs

🔠 Is the MySQL LIKE operator case sensitive?

No, not by default. LIKE follows the collation of the column, and the standard MySQL collations are case insensitive, so ‘code%’ also matches “Code”. Add the BINARY keyword before the column when a case-sensitive match is required.

🔢 Can wildcards be used on numeric and date columns?

Yes. MySQL converts the value to a string before comparing it, which is why year\_released LIKE ‘200\_’ works. The conversion prevents index usage on that column, so filter with ranges such as BETWEEN 2000 AND 2009 on large tables.

🧱 Does MySQL support the \[charlist] wildcard?

No. The bracketed character list accepted by some other engines is not valid inside a MySQL LIKE pattern. Use the [REGEXP operator](https://www.guru99.com/regular-expressions.html) instead, for example title REGEXP ‘^\[a-c]’, to match a range of starting characters.

🤖 Can AI tools write MySQL wildcard queries for me?

Yes. AI assistants translate plain-language requests into LIKE patterns that you can run in a client such as [MySQL Workbench](https://www.guru99.com/introduction-to-mysql-workbench.html). Always review the generated pattern, because moving a single % symbol changes which rows are returned.

🧠 How can AI help optimize a slow LIKE query?

AI query advisors read EXPLAIN output and flag leading-wildcard patterns that skip indexes. They then propose alternatives such as full-text search, a prefix pattern, or [REGEXP](https://www.guru99.com/regular-expressions.html), which you still need to validate against your own data volumes.

#### Summarize this post with:

ChatGPTPerplexityGrokGoogle AI

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.**

##### Sign up for the newsletter

Subscribe for Free

You have successfully subscribed.  
Please check your inbox.

![AI-Newsletter]() Chosen by over **350,000+** professionals

[Scroll to top](#wrapper)

×

Search for:

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/mysql-wildcards.png","url":"https://www.guru99.com/images/mysql-wildcards.png","width":"700","height":"250","caption":"MySQL Wildcards","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/wildcards.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/sql","name":"SQL"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/wildcards.html","name":"MySQL Wildcards: Like, NOT Like, Escape, ( % ), ( _ )"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/wildcards.html#webpage","url":"https://www.guru99.com/wildcards.html","name":"MySQL Wildcards: Like, NOT Like, Escape, ( % ), ( _ )","dateModified":"2026-10-07T16:18:24+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/mysql-wildcards.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/wildcards.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SQL","headline":"MySQL Wildcards: Like, NOT Like, Escape, ( % ), ( _ )","description":"Wildcards are characters that help search data matching complex criteria. Wildcards are used in conjunction with the comparison operator LIKE, NOT LIKE,% percent , _ underscore.","keywords":"sql","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-07T16:18:24+05:30","image":{"@id":"https://www.guru99.com/images/mysql-wildcards.png"},"copyrightYear":"2026","name":"MySQL Wildcards: Like, NOT Like, Escape, ( % ), ( _ )","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"Is the MySQL LIKE operator case sensitive?","acceptedAnswer":{"@type":"Answer","text":"No, not by default. LIKE follows the collation of the column, and the standard MySQL collations are case insensitive, so 'code%' also matches \"Code\". Add the BINARY keyword before the column when a case-sensitive match is required."}},{"@type":"Question","name":"Can wildcards be used on numeric and date columns?","acceptedAnswer":{"@type":"Answer","text":"Yes. MySQL converts the value to a string before comparing it, which is why year_released LIKE '200_' works. The conversion prevents index usage on that column, so filter with ranges such as BETWEEN 2000 AND 2009 on large tables."}},{"@type":"Question","name":"Does MySQL support the [charlist] wildcard?","acceptedAnswer":{"@type":"Answer","text":"No. The bracketed character list accepted by some other engines is not valid inside a MySQL LIKE pattern. Use the REGEXP operator instead, for example title REGEXP '^[a-c]', to match a range of starting characters."}},{"@type":"Question","name":"Can AI tools write MySQL wildcard queries for me?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI assistants translate plain-language requests into LIKE patterns that you can run in a client such as MySQL Workbench. Always review the generated pattern, because moving a single % symbol changes which rows are returned."}},{"@type":"Question","name":"How can AI help optimize a slow LIKE query?","acceptedAnswer":{"@type":"Answer","text":"AI query advisors read EXPLAIN output and flag leading-wildcard patterns that skip indexes. They then propose alternatives such as full-text search, a prefix pattern, or REGEXP, which you still need to validate against your own data volumes."}}]}],"@id":"https://www.guru99.com/wildcards.html#schema-1143628","isPartOf":{"@id":"https://www.guru99.com/wildcards.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/wildcards.html#webpage"}}]}
```