android - How to find value which includes Semicolon(;) sign in SQLite? -

i searching values semicolon(;) sign. have:

select * table value match '; "+lookingfor+"*' 

it giving logic error in sqlite. how explain program ";" not break code piece? doing wrong?

ps. value column example:

apple; orange; banana pineapple; watermelon 

this query:

query = "select id _id,  entry_id ,  re_value,  ke_value,  g_value  search_eng_fts  g_value match '" + lookingfor+ "* or ; "+lookingfor+"*' order length(g_value)  limit 100"; 

the following sql works:

select * list value '%; banana%' 

sql fiddle

although might want take steps avoid sql injection