RE: [sqlite] startswith and contains

2008-01-24 Thread Samuel R. Neff
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 trying "*jup*"

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

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

[sqlite] startswith and contains

2008-01-24 Thread Pavel Kosina
Hello, How to do following queries?: 1/ select * from some where xyz CONTAINS "jup" (anywhere in xyz could be text "jup") 2/ select * from some where xyz STARTSWITH "jup" (the xyz starts with "jup") Thank you. -- Pavel Kosina