Store Array into variable

Question

This is what I am trying but it is not working.

SET @myArray = "25,21,90";

SELECT * FROM aTable WHERE bField IN (@myArray);

I end up getting only the results where bField = 25.

Obviously I am asking this because I have a more complex script than the example above. The @myArray may be used multiple times or buried deap in a longer statement.

Blaise Swanwick · Accepted Answer · 2012-10-24 19:42:34Z

2

You want Find_In_Set:

select * from aTable where FIND_IN_SET(bField, @myArray);

edited Oct 24, 2012 at 19:42

answered Oct 24, 2012 at 18:59

Blaise Swanwick

1,7551 gold badge16 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Store Array into variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related