hey there,
i run a select query in mysql and returns thousands of rows. i want to do a query out of returned result set, and a query out of that result set, and so on so on.
i think i can do this two ways:
-
i was thinking of creating a temporary table and inserting the results into this table, but if a column is fulltext its gotta index the temporary table and that takes a long time.
-
do a select from a select query
anyone with previous experience making search engines can give me some input on the better method, or any other methods?
-Chris
