"Pramoda M. A" <pramod...@kpitcummins.com> wrote in message news:f7846b8f3c78c049b6a1dff861f6c16f0362e...@kcinblrexb01.kpit.com > I have to select using wild charcters? How to do it? > > For eg: I have to select field which should contain "sqlite"... Then > *sqlite* is not working...
select * from mytable where somefield like '%sqlite%'; -- or select * from mytable where somefield glob '*sqlite*'; http://sqlite.org/lang_expr.html#like Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users