Search text in a SQLite Data Base

Databases
1

I have a strange idea:

search text in my sqlite file.

I searched, but do not find.

I do not mean search in a specific Field ( WHERE City='Tokio') but in the whole data base Fields.

Something like
SELECT 'Tokio' in TABLE Employees // Fake code

Is it possible ?

2

Unlikely, I would say. Searches look in columns. I would say this is really a general SQL question rather than specifically for SQLite (or mysql, whatever).

You could ask a question on the SQLite forum:

https://sqlite.org/forum/forum

3

That’s not a proper or good design. You will be forced to lots of (WHERE) f1 LIKE ‘%Tokio%’ OR f2 LIKE ‘%Tokio%’ OR …

Very heavy processing.

Probably it would be better a FTS field full of keywords

4

Thanks Rick.

I asked Gemini and the answer was Full Text Search too.

It even send code, but I’d better scan the ListBox where the data are displayed (far easier to do).

Me think.

5

Done.

I report all found Rows who contains the search string. Sometimes the result is surprising.

2 Likes