Like clause in MySQL

by

MySQL LIKE
In MySQL, the LIKE condition filters the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements based on pattern matching.

Syntax:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
WHERE expressions LIKE pattern [ ESCAPE 'escape_character' ]
WHERE expressions LIKE pattern [ ESCAPE 'escape_character' ]
WHERE expressions LIKE pattern [ ESCAPE 'escape_character' ]

Parameters:

expressions: It is used to specify a column or a field.
pattern: It is used to specify the character expression for pattern matching.
escape_character: It is an optional parameter that is used to test for literal instances of a wildcard character such as

Example: Using wildcard: Percent

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion 100
4 Grocery 90
5 Toys 50

 

Query:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT name
FROM items
WHERE name LIKE 'Ele
<p><strong style="font-size: inherit;"><em>Output:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">NAME
Electronics</pre>
<p><strong><em>Example: Using wildcard: Underscore(_). </em></strong><strong>Items table:</strong></p>
<table>
<tbody>
<tr>
<td width="200"><strong>ID</strong></td>
<td width="200"><strong>NAME</strong></td>
<td width="200"><strong>QUANTITY</strong></td>
</tr>
<tr>
<td width="200"><strong>1</strong></td>
<td width="200">Electronics</td>
<td width="200">30</td>
</tr>
<tr>
<td width="200"><strong>2</strong></td>
<td width="200">Sports</td>
<td width="200">45</td>
</tr>
<tr>
<td width="200"><strong>3</strong></td>
<td width="200">Fashion</td>
<td width="200">100</td>
</tr>
<tr>
<td width="200"><strong>4</strong></td>
<td width="200">Grocery</td>
<td width="200">90</td>
</tr>
<tr>
<td width="200"><strong>5</strong></td>
<td width="200">Toys</td>
<td width="200">50</td>
</tr>
</tbody>
</table>
<p> </p>
<p><strong><em>Query:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">SELECT name
FROM items
WHERE name LIKE 'Elec__onics';</pre>
<p><strong style="font-size: inherit;"><em>Output:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">NAME
Electronics</pre>
<p><strong style="font-size: inherit;"><em>Example: Using NOT. </em></strong><strong style="font-size: inherit;">Items table:</strong></p>
<table>
<tbody>
<tr>
<td width="200"><strong>ID</strong></td>
<td width="200"><strong>NAME</strong></td>
<td width="200"><strong>QUANTITY</strong></td>
</tr>
<tr>
<td width="200"><strong>1</strong></td>
<td width="200">Electronics</td>
<td width="200">30</td>
</tr>
<tr>
<td width="200"><strong>2</strong></td>
<td width="200">Sports</td>
<td width="200">45</td>
</tr>
<tr>
<td width="200"><strong>3</strong></td>
<td width="200">Fashion</td>
<td width="200">100</td>
</tr>
<tr>
<td width="200"><strong>4</strong></td>
<td width="200">Grocery</td>
<td width="200">90</td>
</tr>
<tr>
<td width="200"><strong>5</strong></td>
<td width="200">Toys</td>
<td width="200">50</td>
</tr>
</tbody>
</table>
<p> </p>
<p><strong><em>Query:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">SELECT name
FROM items
WHERE name NOT LIKE 'Ele
<p><strong style="font-size: inherit;"><em>Output:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">NAME
Electronics</pre>
<div class="w3sch-201738414230a768ee03f1de4a1d1711 w3sch-after-content" id="w3sch-201738414230a768ee03f1de4a1d1711"></div> </pre>
SELECT name FROM items WHERE name LIKE 'Ele <p><strong style="font-size: inherit;"><em>Output:</em></strong></p> <pre class="EnlighterJSRAW" data-enlighter-language="js">NAME Electronics</pre> <p><strong><em>Example: Using wildcard: Underscore(_). </em></strong><strong>Items table:</strong></p> <table> <tbody> <tr> <td width="200"><strong>ID</strong></td> <td width="200"><strong>NAME</strong></td> <td width="200"><strong>QUANTITY</strong></td> </tr> <tr> <td width="200"><strong>1</strong></td> <td width="200">Electronics</td> <td width="200">30</td> </tr> <tr> <td width="200"><strong>2</strong></td> <td width="200">Sports</td> <td width="200">45</td> </tr> <tr> <td width="200"><strong>3</strong></td> <td width="200">Fashion</td> <td width="200">100</td> </tr> <tr> <td width="200"><strong>4</strong></td> <td width="200">Grocery</td> <td width="200">90</td> </tr> <tr> <td width="200"><strong>5</strong></td> <td width="200">Toys</td> <td width="200">50</td> </tr> </tbody> </table> <p> </p> <p><strong><em>Query:</em></strong></p> <pre class="EnlighterJSRAW" data-enlighter-language="js">SELECT name FROM items WHERE name LIKE 'Elec__onics';</pre> <p><strong style="font-size: inherit;"><em>Output:</em></strong></p> <pre class="EnlighterJSRAW" data-enlighter-language="js">NAME Electronics</pre> <p><strong style="font-size: inherit;"><em>Example: Using NOT. </em></strong><strong style="font-size: inherit;">Items table:</strong></p> <table> <tbody> <tr> <td width="200"><strong>ID</strong></td> <td width="200"><strong>NAME</strong></td> <td width="200"><strong>QUANTITY</strong></td> </tr> <tr> <td width="200"><strong>1</strong></td> <td width="200">Electronics</td> <td width="200">30</td> </tr> <tr> <td width="200"><strong>2</strong></td> <td width="200">Sports</td> <td width="200">45</td> </tr> <tr> <td width="200"><strong>3</strong></td> <td width="200">Fashion</td> <td width="200">100</td> </tr> <tr> <td width="200"><strong>4</strong></td> <td width="200">Grocery</td> <td width="200">90</td> </tr> <tr> <td width="200"><strong>5</strong></td> <td width="200">Toys</td> <td width="200">50</td> </tr> </tbody> </table> <p> </p> <p><strong><em>Query:</em></strong></p> <pre class="EnlighterJSRAW" data-enlighter-language="js">SELECT name FROM items WHERE name NOT LIKE 'Ele <p><strong style="font-size: inherit;"><em>Output:</em></strong></p> <pre class="EnlighterJSRAW" data-enlighter-language="js">NAME Electronics</pre> <div class="w3sch-201738414230a768ee03f1de4a1d1711 w3sch-after-content" id="w3sch-201738414230a768ee03f1de4a1d1711"></div> </pre>
SELECT name
FROM items
WHERE name LIKE 'Ele

Output:


Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
NAME
Electronics
NAME
Electronics
NAME
Electronics


Example: Using wildcard: Underscore(_). Items table:






ID
NAME
QUANTITY




1
Electronics
30




2
Sports
45




3
Fashion
100




4
Grocery
90




5
Toys
50






 


Query:


Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT name
FROM items
WHERE name LIKE 'Elec__onics';
SELECT name
FROM items
WHERE name LIKE 'Elec__onics';
SELECT name
FROM items
WHERE name LIKE 'Elec__onics';


Output:


Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
NAME
Electronics
NAME
Electronics
NAME
Electronics


Example: Using NOT. Items table:






ID
NAME
QUANTITY




1
Electronics
30




2
Sports
45




3
Fashion
100




4
Grocery
90




5
Toys
50






 


Query:


Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT name
FROM items
WHERE name NOT LIKE 'Ele
<p><strong style="font-size: inherit;"><em>Output:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">NAME
Electronics</pre>
<div class="w3sch-201738414230a768ee03f1de4a1d1711 w3sch-after-content" id="w3sch-201738414230a768ee03f1de4a1d1711"></div>        
SELECT name
FROM items
WHERE name NOT LIKE 'Ele
<p><strong style="font-size: inherit;"><em>Output:</em></strong></p>
<pre class="EnlighterJSRAW" data-enlighter-language="js">NAME
Electronics</pre>
<div class="w3sch-201738414230a768ee03f1de4a1d1711 w3sch-after-content" id="w3sch-201738414230a768ee03f1de4a1d1711"></div>        
SELECT name
FROM items
WHERE name NOT LIKE 'Ele

Output:


Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
NAME
Electronics
NAME
Electronics
NAME
Electronics