MySQL Select on array

Asked Feb 07 '18 at 13:07

Active May 09 '20 at 18:54

Viewed 22 times

I have an array which contains integer values and I would like to do a select on my MySQL database that gives me the datasets that do include the values in that array

$array[0] = 1
$array[1] = 3
$array[2] = 9

And my SQL should be something like

Select * from table where value = Array

Does that work somehow?

edited May 09 '20 at 18:54

Dharman

30,962
25
85
135

asked Feb 07 '18 at 13:07

tpensel

1

post the schema and values for this and the expected results – Funk Forty Niner Feb 07 '18 at 13:10
1

Similar to https://stackoverflow.com/questions/907806/passing-an-array-to-a-query-using-a-where-clause – Nigel Ren Feb 07 '18 at 13:11
1

*"Does that work somehow?"* - Did you try it/something? – Funk Forty Niner Feb 07 '18 at 13:12
You're looking for `IN` – Jay Blanchard Feb 07 '18 at 13:13

MySQL Select on array

0 Answers0