Re: Regarding Sql Table...
So you want to find all occurrences of X in a table without searching the table for X?
Can you ask your question in a way that makes sense?
Re: Regarding Sql Table...
Well, depending on what database you use, I'd say you should make an index on your Genre would properly be the best approach.
It can speed up a query tremendously if made correct. In your example it looks like an index made on genre and id in that order, would be a good starting point.
That way - if your index is made properly - then you'll not have to scan the entire table, but only go through the index and that is something the database should do for you...... depending on which database you use.