UNION function in MySQL, how?

[admin]

Hi,

I'm looking to get a result like this:

SELECT Actor1 as NameActor from Table
union select Actor2 as NameActor from Table
union select Actor3 as NameActor from Table
order by NameActor;

In access I have the Union operator but not in MySQL, have you some
suggestions about !?

Thank you