SQLite Forum

get only first record found
I am using SELECT to search a value 

SELECT * FROM test WHERE available = '1' LIMIT 1


LIMIT seems to still do the work and then discard the extra results
but I only need the first record and want to stop SQLITE after that
to save resources