SELECT INTO (MySQL)?

[Thomas]

hi,

weiss ob in mysql

SELECT *
INTO #temptable
FROM table
WHERE id LIKE 'suchbegriff%'

bzw. dann

SELECT ....
FROM #temptable JOIN ... JOIN ...
moeglich ist?

thanx

-t