I have table , table_A:

I need to store transnumbers in one variable, with condition lpost=0
In MsSQl Server I can use :

SELECT @var1=@var1+','+rtrim(table_A.Transnumber) FROM table_A where lpost=0

In MySQL I try :

Set @var1='';
Select concat(@var1,'-',Transnumber) into @var1 FROM table_A where lpost=0 ;

It doesn’t work

How the right syntax in MySQL?
The result I expect : @var1 = A001,A005

>Solution :

You can use group_concat to help.

Consider:

set @var1 = (select group_concat(transnumber) from table_A where lpost = 0);

Then afterwards:

select @var1;

Gives:

Here’s a dbfiddle with that example.