Trigger with loop from an array

[[e-mail] [e-mail]]

I need in a MySQL Trigger a syntax which can loop from an variable which is defined as an array. Can anyone give me a tip how I can realize this?
Here is the example in Oracle PL/SQL:

var := varArray('element1', 'element2', 'element3)
cntVar := var.count
for i in 1 .. cntVar
LOOP
select var(i) FROM table; x)
END LOOP;

x) or (if the above dynamic sql-statement is not possible in mysql-Trigger):
_ select * from table where column1 = var(i) _

How can I implement this syntax in mySQL trigger-lanquage?

Many thanks!
Anja



Edited 1 time(s). Last edit at 03/20/2014 08:13AM by [e-mail] [e-mail].