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
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
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
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.
> 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%%"
"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
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
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 * from mytable where myfield like
8 matches
Mail list logo