Query SQLite database with similar entries

Question

I have to query an fts3 table inside an android application. The idea is to query the db every time I type something inside a SearchView.

The table is composed by one column that looks like that:

go go
go up
go down

If i use the query:

SELECT * FROM table WHERE column MATCH 'go g*'

I get all three rows as result but I want just the row "go go" in return.

Is there a way to do that? I though about eliminating the spaces, since they seem to be the issue but I wanted to know, if there is a more straight forward solution.

Answer 1

Try

SELECT * FROM table WHERE column LIKE 'go g%'