MySQL Like Operator in PHP

Introduction

In this article I will explain the MySQL "Like" operator in PHP. The MySQL Like operator is based on pattern matching and commonly used to select data based on pattern matching. The LIKE operator allows you to select data from a MySQL database table and therefore this operator is used in the WHERE clause. MySQL provides two characters for using with the LIKE operator, such as percentage "%" and underscore "_". In this article you can learn how to use the Like operator in MySQL.

  • Percentage allows you to match with any characters or string but
  • Underscore allows you to match with any one character.

Example

Like operator with percentage

Use of the like operator with a where clause.  In this query you will see that I selected data from the database using like with percentage.

<html>

<head>

<style>

table

{

border-style:solid;

border-width:2px;

border-color:gray;

}

</style>

</head>

<body bgcolor="#C2DAD3">

<?php

$con = mysql_connect("localhost","root","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("examples", $con);

$result = mysql_query("SELECT id, name, salary FROM employee where name like 'n%'");

echo "<table border='1'>

<tr>

<th>id</th>

<th>name</th>

<th>salary</th>

</tr>";

while($row = mysql_fetch_array($result))

  {

  echo "<tr>";

  echo "<td>" . $row['id'] . "</td>";

  echo "<td>" . $row['name'] . "</td>";

  echo "<td>" . $row['salary'] . "</td>";

  echo "</tr>";

  }

echo "</table>";

mysql_close($con);

?>

</body>

</html>

Your table is:

image1.jpg

If you want to fetch data from the name field starting with the character "n%" then you can do it with:

SELECT id, name, salary FROM employee where name like 'n%';

Output

image2.jpg

If you want to fetch data from the name field ending with the character "%d" then you can do it with:

SELECT id, name, salary FROM employee where name like '%d';

Output

image3.jpg

If you want to fetch data from the name field starting and ending with the character "%a%" then you can do it with:

SELECT id, name, salary FROM employee where name like '%a%';

Output

image4.jpg

Like operator with Underscore

If you want to fetch data from the name field starting with "t" and ending with "m" with any single character between then you can do it with:

SELECT id, name, salary FROM employee where name like 't_m';

Output

image5.jpg 

Up Next
    Ebook Download
    View all
    Learn
    View all