> 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