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 python
&g
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
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 like
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
>
> JOI
8:35 PM Dan 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
> > p
> ON 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
> &g
avin wrote:
> 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)
> >
>
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
sqlite-users@maili
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 got
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 data
10 matches
Mail list logo