Finding existence of a value in a table
| From: | Dennis Gearon | Date: | Wed, 14 Mar 2001 00:07:03 +0000 |
| Subject: | Finding existence of a value in a table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-43738@lists.php.net to get a copy of this message | ||
I would like to return ONE ROW if possible from a query that would tell
me
whether a value exists in a table. I've tried:
SELECT FieldValueIn, COUNT(*) FROM TableOfInterest WHERE
FieldValueIn=ValueOfInterest GROUP BY FieldValueIn;
I can't seem to figure out how to test the return results to see if
there is no
rows with that value. Any help soon would be very nice.