RE: [sqlite] startswith and contains

2008-01-24 Thread Samuel R. Neff
t: Thursday, January 24, 2008 7:28 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] startswith and contains Oh I have no idea. I thought LIKE with '%' was a standard, % being the wildcard. /Jonas On Jan 24, 2008 1:25 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote: > I was still

Re: [sqlite] startswith and contains

2008-01-24 Thread Jonas Sandman
Oh I have no idea. I thought LIKE with '%' was a standard, % being the wildcard. /Jonas On Jan 24, 2008 1:25 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote: > I was still trying "*jup*" > Could you show me documentation page, where this is mentioned? > > Pavel Kosina > > > > Jonas Sandman napsal

Re: [sqlite] startswith and contains

2008-01-24 Thread Pavel Kosina
I was still trying "*jup*" Could you show me documentation page, where this is mentioned? Pavel Kosina Jonas Sandman napsal(a): 1. SELECT * FROM some WHERE xyz LIKE '%jup%' 2. SELECT * FROM SOME WHERE zyx LIKE 'jul%' should work. On Jan 24, 2008 12:44 PM, Pavel Kosina <[EMAIL PROTECTE

Re: [sqlite] startswith and contains

2008-01-24 Thread Jonas Sandman
1. SELECT * FROM some WHERE xyz LIKE '%jup%' 2. SELECT * FROM SOME WHERE zyx LIKE 'jul%' should work. On Jan 24, 2008 12:44 PM, Pavel Kosina <[EMAIL PROTECTED]> wrote: > Hello, > > How to do following queries?: > > 1/ select * from some where xyz CONTAINS "jup" (anywhere in xyz could be > text "