MySQL Query
| From: | Sheridan Saint-Michel | Date: | Wed, 18 Jul 2001 14:27:43 +0000 |
| Subject: | MySQL Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-58438@lists.php.net to get a copy of this message | ||
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