sqlite where clause wildcard?Advertisement
How to use simple select queries with the WHERE clause in SQLite. ... The LIKE operator is used with one or more wildcard characters to select records based on a text string where it is not possible or it would too inconvenient to make an exact match. - read more
The string literal must not begin with a wildcard; ... When faced with the choice of using an index to satisfy WHERE clause constraints or satisfying an ORDER BY clause, SQLite does the same work analysis described above and chooses the index that it believes will result in the fastest answer. - read more
Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or check other resources.