mySQL WHERE IN with array

Question

I have one-dimensional-array $abc.

$abc = array (90, 91, 92, 93, 94, 95, 96, 97, 98, 99);

I want to use it in WHERE IN

SELECT *
FROM table
WHERE columnA IN ()

while (){
$def[] = $row['def'];  
}

When I use simple IN('$abc') I have a response - Undefined variable: def

How to do it properly?

Sarfraz · Accepted Answer · 2012-02-17 11:13:50Z

2

You can use implode() function:

$abc = array (90, 91, 92, 93, 94, 95, 96, 97, 98, 99);
$str = implode(',', $abc);

Now you can use $str in IN clause.

Learn more about implode() function.

answered Feb 17, 2012 at 11:13

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shakti Singh · Accepted Answer · 2012-02-17 11:14:08Z

0

The implode make it easy for you

$query='SELECT *
FROM table
WHERE columnA IN ('.implode(',', $abc).')';

answered Feb 17, 2012 at 11:14

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Comments

Sudhir Bastakoti · Accepted Answer · 2012-02-17 11:14:34Z

0

Try:


$abc = array (90, 91, 92, 93, 94, 95, 96, 97, 98, 99);
$imploded = implode(",", $abc);
//then your query
SELECT *
FROM table
WHERE columnA IN ($imploded)

Hope it helps

answered Feb 17, 2012 at 11:14

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Collectives™ on Stack Overflow

mySQL WHERE IN with array

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related