how to store retrieved data to temporary table with mysql

Question

I have executed one query and I want to store that result set into a temporary table and again I want to re filter the data from temporary table. How can I do this with mysql. Any suggestions please.

Answer 1

CREATE TEMPORARY TABLE temp_tbl
SELECT whatever
FROM wherever
WHERE ...