Select from mysql table WHERE field='$array'?

Question

If I have an array of say, some ID's of users. How could i do something like this:

$array = array(1,40,20,55,29,48);
$sql = "SELECT * FROM `myTable` WHERE `myField`='$array'";

Is there a simple way to do this, I thought about looping through array items and then building up one big "WHERE -- OR -- OR -- OR" statement but i thought that might be a bit slow for large arrays.

Pekka · Accepted Answer · 2010-03-04 21:28:22Z

27

Use IN:

$sql = "SELECT * FROM `myTable` WHERE `myField` IN (1,40,20,55,29,48)";

you can use implode(",", $array) to get the list together from the array.

answered Mar 4, 2010 at 21:28

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

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

Comments

Mark Byers · Accepted Answer · 2010-03-04 21:28:07Z

11

You want to use IN:

WHERE `myfield` IN (1,40,20,55,29,48)

Use implode to construct the string:

$sql = "SELECT * FROM `myTable` WHERE `myField` IN (" . implode(',', $array) . ")";

answered Mar 4, 2010 at 21:28

Mark Byers

843k202 gold badges1.6k silver badges1.5k bronze badges

2 Comments

tarnfeld Over a year ago

So would i do "IN ($array)" ?

Mark Byers Over a year ago

No, use implode to construct the string.

Collectives™ on Stack Overflow

Select from mysql table WHERE field='$array'?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related