Subqueries using the same source table

[Paul Hempsall]

Hi all,

I am a fairly new user to MySQL and database programming in general.

I have written a search engine that compiles an SQL statement based on selected parameters that works great in Access. Now I need to move it to MySQL for an online application.

My problem is that often get SQL statements with subqueries sourcing the same table.

e.g.

SELECT dataID FROM data WHERE data.Name NOT LIKE '???'
AND dataID IN (SELECT dataID FROM data WHERE data.Class LIKE 'arm' OR data.Class LIKE 'hand' OR data.Class LIKE 'fist' )

Is there a way to do this in MySQL without creating endless copies of the original table with different names?