Bad idea... different result than I do description like '%car%' and description like '%london%'
It return nothing. Any ideas ? Anyone tested H2 Fulltext search with multiple condition ? Thanks On Monday, November 23, 2015 at 12:58:20 AM UTC+8, ivan wrote: > > I found a work around... but...not sure this is a proper way to do so... > > SELECT a.name, c.key > FROM > FT.WORDS a, FT.MAP b, FT.ROWS c > where c.ID = b.ROWID and b.WORDID = a.ID and ( a.name like '%car%' or > a.name like '%ms carmen%' or a.name like '%london%' ); > > > On Sunday, November 22, 2015 at 6:31:05 PM UTC+8, ivan ooi wrote: >> >> Hi , >> >> Can I query more than one condition ? >> Like car Ms carmen London >> >> >> Tested but not working >> >> Thanks >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
