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
