SELECT * FROM table WHERE id IN ( SELECT DISTINCT id FROM table WHERE id=1 )
More From khadlock
Tags: mysql
Using the IN statement to retrieve multiple results from a subquery
Use the IN statement to retrieve multiple results from a subquery.