# Mysql query from returned result

**URL:** <https://forum.kirupa.com/t/mysql-query-from-returned-result/126520>\
**Category:** Uncategorized\
**Created:** [October 24, 2004, 11:11pm UTC](https://forum.kirupa.com/t/mysql-query-from-returned-result/126520 "2004-10-24T23:11:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmd](https://avatars.discourse-cdn.com/v4/letter/c/dbc845/32.png) [@cmd](https://forum.kirupa.com/u/cmd)\
**Post date:** [October 24, 2004, 11:11pm UTC](https://forum.kirupa.com/t/mysql-query-from-returned-result/126520/1 "2004-10-24T23:11:58Z")

</div>

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:

1. 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.

2. 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