PHP MySQL Like Operator Example

If you want to search for a specific pattern in a column with where clause then use LIKE operator.

PHP MySQL Like Operator Example:

If you want to search for a specific pattern in a column with where clause then use LIKE operator. This operator is used to specific pattern search in the php application.

Example:

<?php
$connection = mysql_connect("localhost","root","root");

if (!$connection) {
die('PHP Mysql database connection could not connect : ' . mysql_error());
}
else{ 
$db_name = "php_mysql";

mysql_select_db($db_name, $connection);
$sql = "select * from user where user_name LIKE 'b%';";
$records = mysql_query($sql, $connection); 
while($rows = mysql_fetch_array($records)){
echo "User Id : " . $rows['user_id'] . "<br />";
echo "User Name : " . $rows['user_name'] . "<br />";
echo "User Email : " . $rows['user_email'] . "<br />";
echo "User Address : " . $rows['user_address'] . "<br /><br />";
}
}
mysql_close($connection); 
?> 

The database user table records is:

Output:

User Id : 2
User Name : Brijesh
User Email : brijesh@gmail.com
User Address : Delhi

User Id : 3
User Name : Brijesh
User Email : brijeshkumar@gmail.com
User Address : Delhi

Download Example Code