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