I got a scenario where I have to find all rows in Android SQLite db, where a particular column field value lies in the input string. For example,
I am not done yet, I can’t call it a day I need to work more for couple of hours.
Given that your table contains a column
title which has titles that you want to match in the given string, you can do concatenation with
% to use
select * from your_table where 'your input string here' like '%' || title || '%'