[PHP] MySQL Query

[Sheridan Saint-Michel]

I have a table that looks like

Name | Type | X | Y

Foo    | Ship  | 9 | 29
Bar    | Base  | 9 | 29

Is there any way I can write a query that selects
everything with Type = Base, and X and Y = Foo's X and Y?

ie

"Select * from table where type = Base and X = {Foo:X} and Y = {Foo:Y}";

Anyway, any ideas would be greatly appreciated


Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com