PHP MySQL IN Operator Example

If you want to assign multiple values with the where clause to find the records then use IN operator.

PHP MySQL IN Operator Example:

If you want to assign multiple values with the where clause to find the records then use IN operator.

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 IN ('Brijesh','Avanish');";
$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

User Id : 4
User Name : Avanish
User Email : avanish@gmail.com
User Address : New Delhi

User Id : 5
User Name : Avanish
User Email : avanish@gmail.com
User Address : New Delhi

Download Example Code