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*"
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
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
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
4 matches
Mail list logo