SQLite Forum

Return boolean if item EXISTS in database
Login
SELECT EXISTS (SELECT 1 FROM myTable WHERE Company='SmartCO');

Your query would return *all* of the names in myTable if at least one of them is named 'SmartCo'.