Q:

sub query needed I think

I asked this question yesterday and  am reposting a very simple version of it to make sure 
there was no confusion as to what I am attempting. 
adam    toyota
joe     toyota
rick    mazda

SELECT * FROM table WHERE  
  name LIKE adam
  and also return rows where name is not adam but have the same car as adam. 

So a search for adam would return rows: adam & joe. 

A:

SELECT * FROM `table` WHERE `name` = 'adam'
OR car IN (
    SELECT car FROM `table` WHERE `name` = 'adam'
)

The "name is not adam but" part is not really making sense, since you will get all adams anyway.