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: [email protected] on behalf of [email protected]
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" <[email protected]>
Sent: Wednesday, May 26, 2010 12:54 PM
To: "General Discussion of SQLite Database" <[email protected]>
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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
