Thank you also Petite
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence


On 5 October 2016 at 11:00, Paul Sanderson <sandersonforens...@gmail.com> wrote:
> Brilliant thansks Dominique - I had completely misunderstood it :)
> Paul
> www.sandersonforensics.com
> skype: r3scue193
> twitter: @sandersonforens
> Tel +44 (0)1326 572786
> http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
> -Forensic Toolkit for SQLite
> email from a work address for a fully functional demo licence
>
>
> On 5 October 2016 at 10:53, Dominique Devienne <ddevie...@gmail.com> wrote:
>> On Wed, Oct 5, 2016 at 11:50 AM, Paul Sanderson <
>> sandersonforens...@gmail.com> wrote:
>>
>>> Thanks Petite - I have already looked at that - but how?
>>>
>>
>> sqlite> create table t (v);
>> sqlite> insert into t values
>>    ...> ('I got 20 quid'),
>>    ...> ('i got 20% of it'),
>>    ...> ('i got just 20%'),
>>    ...> ('some money'),
>>    ...> ('this is an underscore _ ok');
>> sqlite> select * from t where v like '%20!% %' escape '!';
>> i got 20% of it
>> sqlite>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to