SQLite Forum

[SELECT] Simple way to search for data that start with given pattern?
Login
And your syntax is incorrect.

```
SELECT COUNT(*) FROM MyTable WHERE zip LIKE "01%" OR LIKE "04%" etc.

```

should be

```
select count(*) from mytable where zip like '01%' or zip like '04%' etc.
```

double quotes are for identifiers.  single quotes are for strings.

Unlike English (or COBOL) you cannot elide the subject of the likeness.