Re: exist

[Martin Hall]

Jon,
>>>>>>>>>>>>>>>>>>
SELECT COUNT(*) > 0 FROM tablename WHERE username='$username';

will return 1 (true) if there are any records in the table named 'mytable' where the username is $username and 0 (false) if there aren't.
>>>>>>>>>>>>>>>>>>

This interests me, as I often need to establish whether a matching record exists
without necessarily retrieving the record.

Can you say how your solution compares, performance-wise, with this:
SELECT * FROM tblname WHERE field = '$data'
and then returning a count of the resulting record-set
??

Thanks in advance.