Hi!

<cut>

Carlos> Ok, ok, I surrender, I'm not gonna argue about this anymore, but I'd
like Carlos> to abuse a little more of your patience if you will...

Carlos> I want to develop a search systems that uses a cache: if you look for Carlos> something then you got the first X items, then if you hit the "show me
the Carlos> next X hits" button I won't make that search again; instead of that,
I'll Carlos> show you the following records from the cache already mentioned.

Carlos> Since Mysql doesn't support SELECT... INTO yet

<cut>

MySQL does support the syntax:

INSERT INTO table SELECT ...

This is basicly the same thing as what you are asking for and this is the ANSI SQL way to do it!

Regards, Monty