I have a database with 9 columns minimum and about 1000 rows. I need to
lookup the complete table for a specific string. At the moment I do it like below
but I have a feeling that this could be easier and faster:
I tried to find the answers in the sqlite manuals but suffering from examples and to be honest I am
pretty new teh database stuff.
Yes, the inquiry is fast but building the sqlite string with concateing the string seems
like “unprofessianl”. I also think it’s good to understand the sqlite engine and how powerful it is. I will give
the FTS a try through. That’s what I found in the internet too but at the first glance it seems a bit difficult
to understand. -> “wrap your head around”
You can use the Database.FieldSchema to get the field list, and dynamically build the select string. Make this a global method, or extend the Database class, and you could use it on any table/database.