I am starting to write mysql. I am finding select rather difficult. I want to select a number of records. Yet I am not sure how to do it.

There are two options. I make a wider select then loop through each one. Having to go through a thosand records.

I could then make smaller select. yet I would then have to make 20-30 specific searches.. 30 select statements rather than just one.

Can I make a select statement and then try to selct from the select?

Its just I am trying to make a forum and its rather difficult. I would have to use fast code.