Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

It will crash or exit the program. On Thu, Oct 18, 2018 at 2:27 PM Jens Alfke wrote: > > > > On Oct 18, 2018, at 11:17 AM, Maziar Parsijani < > maziar.parsij...@gmail.com> wrote: > > > > I just search for words an alphabets in different languages with pytho

Re: [sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

on sqlite. On Thu, Oct 18, 2018 at 8:25 AM Bob Gailer wrote: > On Oct 18, 2018 5:59 AM, "Maziar Parsijani" > wrote: > > > > Hi, > > how could I ignore syntax errors like this? > > > > > *SELECT *,* > > > > > > * highlight(searchsimpl

[sqlite] [SQLITE]ignoring syntax errors during search for sth include "symbols"

Hi, how could I ignore syntax errors like this? > *SELECT *,* > > * highlight(searchsimpleenhanced, 2, '', '') text* > > * FROM searchsimpleenhanced* > > * WHERE searchsimpleenhanced MATCH 'sth][';* > there maybe nothing to match but I don't like to get syntax errors for a symbol or character

[sqlite] [SQLITE] 3 questions.(tokenize in fts5)(number of highlights)(ignoring syntax errors for searching "symbols")

Hi, I have 3 questions on the below query: > SELECT searchsimpleenhanced.rowid, > > searchsimpleenhanced.*, > > fatrans.text AS trans, > > searchfast.text, > > highlight(fatrans, 0, '', '') mjp > > FROM searchsimpleenhanced > > JOIN > > fatrans ON fatrans.rowid = searchsimpleenhanced.rowid > >

Re: [sqlite] FTS5 MATCH using "string*" matches just the exact string

an Kennedy wrote: > On 09/11/2018 01:26 PM, Maziar Parsijani wrote: > > Thanks for your answer Eric,Sandu > > About the first idea of Eric I have to say its correct for me when I do a > > test with another fts5 table with no huge rows but my database has that > > problem.And

Re: [sqlite] [SQLITE]select from a table and use its data to select from another one

N table1.rowid = table2.rowid > >> WHERE table1.name LIKE '%smth%' > >> > >> > >> -Original Message- > >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org > ] > >> On Behalf Of Simon Slavin > >> Sent: Friday,

Re: [sqlite] [SQLITE]select from a table and use its data to select from another one

gt; On 14 Sep 2018, at 6:50pm, Maziar Parsijani > wrote: > > > I have 2 tables with the same rowid now I want to : > > select rowid from table1 where table1 like "%smth%" > > select * from table2 where rowid =(selected rows before) > > > > I m

[sqlite] [SQLITE]select from a table and use its data to select from another one

Hi, I have 2 tables with the same rowid now I want to : select rowid from table1 where table1 like "%smth%" select * from table2 where rowid =(selected rows before) I mean if I could do it in a same query. ___ sqlite-users mailing list

Re: [sqlite] FTS5 MATCH using "string*" matches just the exact string

Thanks for your answer Eric,Sandu About the first idea of Eric I have to say its correct for me when I do a test with another fts5 table with no huge rows but my database has that problem.And about the other possibility I tested that before to set "*"at the first and end of the match but I have

[sqlite] FTS5 MATCH using "string*" matches just the exact string

Hi I am new here and I am not an expert on sqlite my question is about match option that I have read from https://sqlite.org/fts5.html but the problem is when I want to not find the exact word so I use : SELECT rowid,text FROM table WHERE table MATCH 'أعلم*'; And I have to add this that my