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 vote138 views1 answer
Sql trying to delete database in use
SQL
0 vote128 views1 answer
Oracle tablespace autoextend
SQL
3 votes134 views1 answer
Sql multiple column index
SQL
0 vote154 views1 answer
Allow null in psql
SQL
0 vote168 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
3 votes153 views1 answer
Oracle revoke
SQL
0 vote137 views1 answer
Mysql where don't have string
SQL
0 vote135 views1 answer
18446744073709551615 mariadb left join order by
SQL
23 votes147 views6 answers
Create table sql server
SQL
0 vote179 views1 answer
Grouping by email domain mysql
SQL