How do I select rows where a column value starts with a certain string? May 27, 2023 by Tarik You can do select * from mytable where name like "Mr.%" See http://www.sqlite.org/lang_expr.html