On Tue, Feb 28, 2012 at 1:47 AM, Jitendra Shrivastava < jitendra.s...@gmail.com> wrote:
> Hi, > > I am using GLOB in Where clause with character '[' like below: > > select * from TableName where ColumnName GLOB '*[*'; > > Table is having data in ColumnName like "ABC[XYZ", but it is not able to > find match. How to achieve this record using GLOB. For other characters > this statement is working fine. > SELECT * FROM tableName WHERE columnName GLOB '*[[]*'; > > > Thanks, > Jitendra > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users