SQLite User Forum

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'.