SQL(ite) question

[Klaus major-k]

Hi all,

I searched the docs of SQLite but could not find a hint.

Is it possible to create a "full text search" in SQL(ite)
with ONE SQL command? Something like this (pseudocode):
...
SELECT * from MyTable where ANY_COLUMN like "%mysearchtermhere%"
...
If not, how can this be done?

You get the picture, any hints appreciated, thank you.


Best

Klaus
--
Klaus Major
https://www.major-k.de
klaus at major-k.de