Lukas Kahwe Smith <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> >> I am working on integrating pattern character escaping into PEAR::MDB2.
> >> I am using PHP's ext/sqlite which only supports SQLite version 2
> >> (version 3 is supported only through pecl::pdo_sqlite).
> >>
> >> Is it possible to have literal % and _ in LIKE expressions in version 2?
> >> Since when is ESCAPE supported? I presume its another version 3 only
> >> feature?
> >>
> >
> > Correct. ESCAPE was added in version 3.1.0.
>
> And there is no alternative way to be able to use literal % and _ in
> version 2?
>
1. Use GLOB instead of LIKE
2. Create an register your own implementation of LIKE that
allows escape characters.
--
D. Richard Hipp <[EMAIL PROTECTED]>
