the site I need to
know if this is an efficient way to keep the FTS table updated.
Also, is there any pragma or so to tell FTS to automatically search for
parts of words, instead of requiring users to add *?
As said, thanks for any help and sorry for my bad english.
--
Saluti da Gabriele F
k=utenti.id
INNER JOIN categorie ON otopic.categoria=?
WHERE otopic.pub=1
ORDER BY otopic.sticky,otopic.inserito DESC
Sorry for table names in italian
utenti = users
messaggi = messages
--
Saluti da Gabriele Favrin
http://www.favrin.net
___
sqlite-users
ies, and so on...
Or such a select would be complicated and is best to count so an index
for replyto is required, and it's already there) and do a 2nd select?
Thanks in advance and sorry for my BAD english.
--
Saluti da Gabriele Favrin
http://www.favrin.net
___
3 matches
Mail list logo