Question: I have a problem about create a query for text-searching starting at begining of column character. For example: I have a table 'BOOK' with a column 'TITLE'. I have 3 rows in 'BOOK' table with 'TITLE' values are: 'ANDROID APPLICATION', 'ANDROID APP DEVELOPMENT' and 'ANDROID APPLICATION PROGRAMMING'. 

Now when my input is 'ANDROID APP', I need all 3 rows matched. When I type 'ANDROID APPLICATION', I need 2 rows matched: 'ANDROID APPLICATION' and 'ANDROID APPLICATION PROGRAMMING'. And when I type 'APP' or 'APPLICATION', I need no row matched (because we want to start searching at begining character of column value).

I've read the SQLite FTS document but I dont know how to use prefix query, phrase query... together with AND, OR, NOT operation to solve my problem? Anyone could give me an approriate query syntax?

Answer: 
FTS cannot search from the beginning of a column value.
(Actually, it can, but this is undocumented and not enabled in Android.)

To search from the beginning, you have to use `LIKE 'pattern%'`.
If you want this to be efficient, you have to use this with a normal table and a case-insensitive index ([COLLATE NOCASE](http://www.sqlite.org/lang_createindex.html)).
Try below:

```
String name = your book name which entered by search box;

String sql ="select "+TITLE+" from "+BOOK+" where TITLE like '"+ name +"%'";

```