"Pramoda M. A" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
