sqlite search query for finding a particular data from column?

Question

I am making app for finding number plates of india. my database contains two columnns "code" and "city" code contains data like MH1,MH2 etc. and city contains data like Pune,Mumbai.

App contains one edittext box and listview.

Listview consists whole data from database like GJ3 Rajkot, GJ10 Jamnagar etc.

if i write GJ in edittext box whole only data of GJ must be apperaed in listview.

Answer 1

Here is the query : SELECT * FROM table_name WHERE code LIKE '%GJ%' LIMIT 0 , 30