Sqlite fields ID

[TIMAI2]

Which sqlite extension are you using ?

What are the bindParams for in your project? Possibly you mean this?

GitHub - frdfsnlght/aix-SQLite: AppInventor extension for SQLite

Use the
"SELECT * FROM tbl1 WHERE X contains 'Y';"
or
"SELECT * FROM tbl1 WHERE X LIKE '%Y%';"
or
"SELECT * FROM tbl1 WHERE instr(X, 'Y') > 0;"

query to find the value in a sentence

See also here:

HOWTO: Use sqlite3 with @Juan_Antonio's Terminal Extension

NOTE: The file access restrictions put in place on the latest android version (10/11/+) may prevent this from working, because the linux sub system is not given any file access permissions, from the testing I have done. Many thanks to @Juan_Antonio for the Terminal extension, without which this would not be possible. Provides for the use of the sqlite program in most android devices. This is a simple demo of the functionality (hopefully soon a more fully featured version) [tsqlimg2]