You could do

SELECT whatever FROM table WHERE criteria LIMIT 1

or

SELECT COUNT(*) AS RowCount FROM table WHERE criteria

Then just check that the value of RowCount > 0.  The nice thing about the 
latter is that now you are set up if you ever want to know how many rows meet 
the criteria that you've chosen.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -------------- Original message ----------------------
From: arbalest06 <[EMAIL PROTECTED]>
> 
> Good day!
> 
> I want to retrieve only one record in the database with a condition that may
> cause a retrieval of many records. The purpose of this is for me to check
> only if there is at least 1 record in the database. So if given my
> condition, the query would now search for one record in the database that
> satisfies the condition the returns that record. After one record is found,
> it should now stop finding and retrieving other records that satisfies the
> condition. How can i do this? What query can i issue?
> 
> Thank you and God bless!
> -- 
> View this message in context: 
> http://www.nabble.com/Retrieving-only-one-record-in-the-database-tp15087994p1508
> 7994.html
> Sent from the SQLite mailing list archive at Nabble.com.
> 
> 
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
> 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to