Let's say that I have this:

@var_user = 'user_1';

INSERT INTO tableA
 SELECT username, columnA FROM tableB
 WHERE username=@var_user;

That's just a sample code, so please forgive any typos or glaring errors.

But now, I want to insert, say, 50 lines, with 50 different usernames. I know I could write a PHP script for it, but it would be a lot easier if I could just copy and paste a code into PMA.

I'm hoping that something exists like:

@var_user_array = (
 'user_1',
 'user_2',
 'user_3',
 ...
 'user_50'
);

INSERT INTO tableA
 SELECT username, columnA FROM tableB
 WHERE username=@var_user_array;

or maybe something like this:

@var_user_array = (
 'user_1',
 'user_2',
 'user_3',
 ...
 'user_50'
);

FOREACH @var_user (@var_user_array) {
 INSERT INTO tableA
  SELECT username, columnA FROM tableB
  WHERE username=@var_user;
}

I've been searching Google and can't find anything like that, but I know I'm not the first person to wish for it.

Can you guys suggest anything other than writing a PHP script for it?