Full text search with SQLite using prefixes and suffixes at the same time efficiently

0

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!

    
asked by Pedro Urday 15.12.2018 в 23:58
source

0 answers