SQLite Forum: Return boolean if item EXISTS in database

☰About Threads Post Subscribe SQLite

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