"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."

Choose a escape character and put it before any of the meaningful ones in
your query to escape it.

--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/escaping-GLOB-pattern-tp62528p62538.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to