(How) are subqueries optimized involving the same table?

[Jakobus Dornier]

Hi,

I couldn't find this in the docs:

In a query like

SELECT
foo,
(SELECT field1 FROM t2 WHERE t2.id = 123),
(SELECT field2 FROM t2 WHERE t2.id = 123),
(SELECT field3 FROM t2 WHERE t2.id = 123)
FROM
t1 WHERE id = 7;

--> does mysql have to access the table "t2" three times?

Thank you in advance for any advie.
Jay