How do I select rows where a column value starts with a certain string?

Question

How do I select rows where a column value starts with a certain string ?

For example, I'd like to select the rows whose 'name' column starts with "Mr.".

Answer 1

You can do

select * from mytable where name like "Mr.%"

See http://www.sqlite.org/lang_expr.html