Thanks Petite - I have already looked at that - but how? How do I search for a % symbol within a string when % is a wild card and I am escaping that very wildcard? 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:44, Petite Abeille <petite.abei...@gmail.com> wrote: > >> On Oct 5, 2016, at 11:38 AM, Paul Sanderson <sandersonforens...@gmail.com> >> wrote: >> >> How casn I find just the rows containing the percent symbol? is it possible? > > Use the ESCAPE clause: > > "If the optional ESCAPE clause is present, then the expression following the > ESCAPE keyword must evaluate to a string consisting of a single character. > This character may be used in the LIKE pattern to include literal percent or > underscore characters. The escape character followed by a percent symbol (%), > underscore (_), or a second instance of the escape character itself matches a > literal percent symbol, underscore, or a single escape character, > respectively.” > — The LIKE, GLOB, REGEXP, and MATCH operators > > https://www.sqlite.org/lang_expr.html > _______________________________________________ > 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
