If you want to search a field in SQLite you might use a query like this:

SELECT MyID FROM Table WHERE Name = 'Doolis';

This performs a case-sensitive search on the Name field. If you want to search the name field in a case-insensitive manner do this:

SELECT MyID FROM Table WHERE Name = 'Doolis' COLLATE NOCASE;