Re: [sqlite] How to Select using Wild Characters?
"Pramoda M. A" 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
Re: [sqlite] How to Select using Wild Characters?
Use % (percent instead of * and use _ (underscore) instead of ? Pramoda M. A wrote: > Hi All, > > > > 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... > > Pleas help me. > > > > With Regards > > Pramoda.M.A > > KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905 > > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users