Mysql where in array

-- SQL
SELECT * FROM table WHERE column IN('value1','value2','value3')

-- Javascript
$string="1,2,3,4,5";
$array=array_map('intval', explode(',', $string));
$array = implode("','",$array);
$query=mysqli_query($conn, "SELECT name FROM users WHERE id IN ('".$array."')");

Source: stackoverflow.com

Select values from mysql using php array of ids

$sql = 'SELECT * 
          FROM `table` 
         WHERE `id` IN (' . implode(',', array_map('intval', $array)) . ')';

Source: stackoverflow.com

Similar codes

0 vote365 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
2 votes322 views1 answer
Oracle cpu per session
SQL
0 vote373 views1 answer
Select the date 30 days less that the todays date sql request
SQL
12 votes327 views4 answers
Install mysql ubuntu 18.04
SQL
51 votes715 views6 answers
Installing mysql on ubuntu
SQL
0 vote336 views1 answer
Restore backupfile discourse
SQL
0 vote322 views1 answer
Oracle right characters
SQL
8 votes333 views3 answers
Alter table auto_increment
SQL
3 votes345 views3 answers
Docker create postgresql database
SQL
0 vote393 views1 answer
What logs are available on RDS MySQL?
SQL