Dunnigan Pierce wrote:
> hi, sorry if this has been asked before or is hidden somewhere in the
> documentation. couldn't find an archive of this list to search through and
> couldn't find it in the docs.
>
> how do you escape " and % in sqlite? in other dbs you can do something like:
>
>
> select
"D. Richard Hipp" <[EMAIL PROTECTED]> writes:
> As an interim workaround, you could defined your own
> "like()" function using the sqlite_create_function() API
> that implemented built-in escapes. Any user-defined
> function named "like()" is used to implement the LIKE
> keyword of SQL.
That see
> how do you escape " and % in sqlite? in other dbs you can do
> something like:
>
> select * from mytable where myfield like "%100[%]%";
> or
> select * from mytable where myfield like "%100\%%";
> but neither seem to work with sqlite
Try this:
select * from mytable where myfield like "%100%%"
thanks, that worked like a charm.
tim
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
Dunnigan Pierce wrote:
> hi, sorry if this has been asked before or is hidden somewhere in the
> documentation. couldn't find an archive of this list to search through and
> couldn't find it in the docs.
On Mon, 2004-01-26 at 09:08, [EMAIL PROTECTED] wrote:
> "D. Richard Hipp" <[EMAIL PROTECTED]> writes:
>
> > As an interim workaround, you could defined your own
> > "like()" function using the sqlite_create_function() API
> > that implemented built-in escapes. Any user-defined
> > function named
MAIL PROTECTED]
Sent: Tuesday, January 27, 2004 12:27 PM
To: [EMAIL PROTECTED]
Cc: D. Richard Hipp; [EMAIL PROTECTED]
Subject: Re: [sqlite] escaping " and % in sql statements
On Mon, 2004-01-26 at 09:08, [EMAIL PROTECTED] wrote:
> "D. Richard Hipp" <[EMAIL PROTECTED]> writes
gt;
> { "like", 2, SQLITE_NUMERIC, my_like_function },
>
> then?
>
> -Original Message-
> From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 27, 2004 12:27 PM
> To: [EMAIL PROTECTED]
> Cc: D. Richard Hipp; [EMAIL PROT
7 matches
Mail list logo