I am at a complete loss for something that should be very simple to find in SQLite. In the IMDB database, I have to find how many actors have the name 'Meryl', I have tried select name, count(name) from people where name='Meryl'; and select count(name) from people where name='Meryl'. Nothing comes up even though I know for a fact there are 15 in the database because I have counted.

I have tried with other names and it works fine and even with Meryl Streep and it works. I don't know what I'm doing wrong. Please help!

1 Answer 1


Not sure but maybe try using LIKE ?

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .