Creating array variable in MySQL

Question

I am wondering can you create an array variable in MySQL? I know that you can create a normal variable like so SET @var1 = "myvar"; but is there a way of creating an array? If so how?

Did you try google? stackoverflow.com/questions/12176709/… — Digital Chris
– Digital Chris, Commented Dec 30, 2013 at 18:52
MySQL does not support arrays. Neither in the procedural language nor as a data type. — user330315
– user330315, Commented Dec 31, 2013 at 11:37

Michael Zajac · Accepted Answer · 2016-08-10 13:43:06Z

15

You can create an array like so

SET @arrayVar = 'var1,var2,bar3,foo4';

It can be used thus

select from myTable where find_in_set(myTable.myColumn, @arrayVar);

If you want to create an array from a query, you can use temporary tables

create temporary table if not exists tmp_table select myColumn from myTable where

edited Aug 10, 2016 at 13:43

Michael Zajac

55.7k7 gold badges120 silver badges143 bronze badges

answered Dec 17, 2014 at 10:35

Igbanam

6,1025 gold badges49 silver badges75 bronze badges

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

1 Comment

yoni Over a year ago

works also on calculated value like : find_in_set(month(mytable.myDate), @arrayVar)

Collectives™ on Stack Overflow

Creating array variable in MySQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related