On Mon, Feb 2, 2009 at 12:33 PM, J. R. Westmoreland <j...@jrw.org> wrote: > Please pardon me if this is really more SQL rather than sqlite behavior. > > > > If I have some thing like: > > SELECT . WHERE . LIKE "String" .; > > Is it going to work like: > > SELECT . WHERE . = "String" .; > >
LIKE is case-insensitive, and typically used with wild cards. WHERE col = 'String' would be case-sensitive and only match 'String' whereas LIKE will match 'String' and 'string' Compare with GLOB which is case-sensitive. In either case, you want to use single-quotes, not double-quotes. > > Thanks, > > J. R. > > > > -------------------- > > J. R. Westmoreland > > E-mail: j...@jrw.org > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users