This works for me: sqlite> create table t(t varchar); sqlite> insert into t values('Testing*with asterisk'); sqlite> insert into t values('Testing without asterisk'); sqlite> select * from t; Testing*with asterisk Testing without asterisk sqlite> select * from t where t like '%*%'; Testing*with asterisk Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of ro...@zhole.com Sent: Wed 5/26/2010 12:14 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] how to search for asterix character? I use vb or in SQLlite Expert the * does not seem to work >From my testing * doesn't seem to work in the likeif I use '%33' it returns everything with test33if I use '33%' it returns everything with 33testif I use '%33%' it returns everything with 33test, test33 which is the same as * Hope this helpsRoger ---------------------------------------- From: "Jean-Christophe Deschamps" <j...@q-e-d.org> Sent: Wednesday, May 26, 2010 12:54 PM To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Subject: Re: [sqlite] how to search for asterix character? >How do I search for the asterix character * ?? > >This doesn't work: >select field1 from table1 where field1 like '%FH%*%' >as the * character here seems to be ignored. > >Using the latest version of SQLite. You're doing it right. Either you use a wrapper that messes with * in litterals or there is actually no matching row. Try using the command-line tool to better diagnose what's going on here. _______________________________________________ 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
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users