I would like to know how I perform the following SQL query:
SELECT * FROM libros WHERE titulo LIKE '%caball%' OR titulo LIKE '%pur%' OR titulo LIKE '%sangr%' OR ...;
but using "Full Text Search" with SQLite and efficiently.
I do not like to use the "LIKE" clause because it seems very rudimentary to me.
Can you?
Greetings!