Is it possible to change the field name in a query for a selection, only for this query?

Question

MySQL

Here is a request

SELECT t1.image,t2.image FROM matches INNER JOIN teams AS t1 ON t1.name = matches.name_one INNER JOIN teams AS t2 ON t2.name = matches.name_two

I select two fields, t1.image and t2.image
But they are displayed with the same names, respectively.

And how can we add some numbers or letters to the selections so that they are different?
PS type as avg operator

Answer 1

SELECT t1.image as myname1 ,t2.image as myname2 FROM ...