[odb-users] [Search of feature] LIKE in the ODB query language

grignon florian grignon.florian at gmail.com
Wed Mar 13 04:05:29 EDT 2013


Hi Boris,

Sorry for the delay,

I will let you know how it works.

Thank you,

Florian

On 02/21/2013 12:46 PM, Boris Kolpackov wrote:
> Hi Florian,
>
> florian grignon<grignon.florian at gmail.com>  writes:
>
>> I would be very glad to have your patch when you're done with it.
> Ok, I've added the SQL LIKE support for the next release (2.3.0). To
> try it with 2.2.0, you will need to do the following:
>
> 1. Apply the following patch to libodb-2.2.2:
>
>    http://scm.codesynthesis.com/?p=odb/libodb.git;a=patch;h=4962329eecb716bc2b99810ec1ac4214606fc1e8
>
> 2. Apply the following patch to libodb-sqlite-2.2.0 (similar patches for
>     all the other database runtimes are available):
>
>    http://scm.codesynthesis.com/?p=odb/libodb-sqlite.git;a=patch;h=b580f1548ff335a0e1fa004fc6626486535c94e1
>
> Once, this is done, you can use the new like() function like this:
>
> query::name.like ("J%");
>
> Or, with the escape character:
>
> query::name.like ("%!_Doe", "!");
>
> Let us know how it works for you.
>
> Boris



More information about the odb-users mailing list