array of comma separated string IN in clause mysql

Question

I have a array like that :

 $myarray=  'zzz,aaa,bbb'  ;

and want use it in mysql IN clause like that :

 "...  WHERE ids IN ($myarray) "   // didnt work 
 "...  WHERE ids IN ('$myarray') " // didnt work

the error im getting is that the first value in that array zzz says that zzz is not a column name . so i understand that i must separate the values with quotes to be like that :

 $myarray=  ' "zzz","aaa","bbb" '  ;

But i have no clue to do that . any help would be much appreciated.

Because it really isn't an array, it's a string. You need to implode with the appropriate quotes and commas. — Jay Blanchard
– Jay Blanchard, Commented Mar 2, 2015 at 19:31
The end result should look like this: WHERE ids IN ('zzz','aaa','bbb') — KIKO Software
– KIKO Software, Commented Mar 2, 2015 at 19:33
@JayBlanchard you mean i use this ` ids IN implode(", ", $myarray); ` ? — Scooter Daraf
– Scooter Daraf, Commented Mar 2, 2015 at 19:34
Lot's of good answers here @ScooterDaraf - the one liners are especially elegant. My example shows what is going on line by line. — Jay Blanchard
– Jay Blanchard, Commented Mar 2, 2015 at 19:36
As a side note, you should maybe not call your variable $myarray if it isnt an array. Giving good names, makes it easier to maintain code. — alfallouji
– alfallouji, Commented Mar 2, 2015 at 19:44

KIKO Software · Accepted Answer · 2015-03-02 19:34:47Z

4

$myarray = 'zzz,aaa,bbb';
$myarray = implode("','",explode(',',$myarray));
$query   = "..... WHERE ids IN ('$myarray')";

answered Mar 2, 2015 at 19:34

KIKO Software

17.5k3 gold badges33 silver badges53 bronze badges

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

1 Comment

Scooter Daraf Over a year ago

I dont know why id doesnt work with 2 strings and more, it works just with single string .

Jay Blanchard · Accepted Answer · 2015-03-02 19:35:09Z

3

You need to explode() your string and then implode() it -

$myarray = 'zzz,aaa,bbb'; 
$realArray = explode(',', $myarray);
$stringForIn = "'" . implode("','", $realArray) . "'";
echo "WHERE ids IN ($stringForIn)";

answered Mar 2, 2015 at 19:35

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

4 Comments

Scooter Daraf Over a year ago

I dont know why id doesnt work with 2 strings and more, it works just with single string

Jay Blanchard Over a year ago

Without knowing more about your database it would be hard to know why it isn't working. Can you update your original post with the entire query and your table layout @ScooterDaraf?

Jay Blanchard Over a year ago

Can you echo the full query @ScooterDaraf? So far I'm not seeing an issue.

Jay Blanchard Over a year ago

Let us know if you need us to look further @ScooterDaraf. Make sure to update your post with the appropriate code so we can see what is going on.

alfallouji · Accepted Answer · 2015-03-02 19:35:17Z

1

Try that :

$myarray=  'zzz,aaa,bbb'  ; 
echo implode '"' . ('","', explode(',', $myarray)) . '"';

answered Mar 2, 2015 at 19:35

alfallouji

1,1708 silver badges12 bronze badges

Collectives™ on Stack Overflow

array of comma separated string IN in clause mysql

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related