Also...what do you get from a .dump ?? Any extra chars should show up in the
SQL statements.
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
________________________________
From: sqlite-users-boun...@sqlite.org on behalf of ecforu
Sent: Fri 4/30/2010 8:53 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] WHERE = does not work
I don't think it is a case issue. See below from sqlite3 command line.
Also one thing to note - I build the database from c API. I don't know if
that makes a difference.
sqlite>
sqlite> select timeStamp, resourceType From MyTable where resourceType like
'PSM' LIMIT 10;
timeStamp|resourceType
2010-04-28 17:46:45.316|PSM
2010-04-28 17:46:49.854|PSM
2010-04-28 17:46:52.830|PSM
2010-04-28 17:47:04.939|PSM
2010-04-28 17:47:06.776|PSM
2010-04-28 17:47:08.846|PSM
2010-04-28 17:47:12.001|PSM
2010-04-28 17:47:13.845|PSM
2010-04-28 17:47:16.837|PSM
2010-04-28 17:47:18.846|PSM
sqlite>
sqlite>
sqlite> select timeStamp, resourceType From MyTable where resourceType =
'PSM' LIMIT 10;
sqlite>
sqlite>
sqlite>
THANKS
On Fri, Apr 30, 2010 at 9:35 AM, Black, Michael (IS) <michael.bla...@ngc.com
> wrote:
> You are likely getting the case insensitive result with "like".
>
> sqlite> create table t(resourceType varchar);
> sqlite> insert into t values('PSM');
> sqlite> insert into t values('psm');
> sqlite> select * from t where resourceType = 'PSM';
> PSM
> sqlite> select * from t where resourceType like 'PSM';
> PSM
> psm
> sqlite> select * from t where upper(resourceType) = 'PSM';
> PSM
> psm
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
> ________________________________
>
> From: sqlite-users-boun...@sqlite.org on behalf of ecforu
> Sent: Fri 4/30/2010 8:31 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] WHERE = does not work
>
>
>
> But the like WHERE clause works the way it is. Its the = that isn't
> working. I would rather use = than like. I'm just using like for now
> because it works.
>
> Thanks
>
> On Fri, Apr 30, 2010 at 9:29 AM, Timothy A. Sawyer <
> tsaw...@mybowlingdiary.com> wrote:
>
> > With the like clause you have to use the % sign as a wildcard. So
> > resourceType LIKE %'PSM' returns anything ending in PSM. The SQLite
> website
> > has excellent docs on standard SQL.
> >
> > -----Original Message-----
> > From: ecforu <ecforus...@gmail.com>
> > Sent: Friday, April 30, 2010 09:22
> > To: sqlite-users@sqlite.org
> > Subject: [sqlite] WHERE = does not work
> >
> > I have an sqlite3 database which I can't query with WHERE =. I have to
> use
> > WHERE like.
> >
> > Any ideas why this is?
> >
> > For example I have a resourceType column that has as some of its entries
> > (over 50) 'PSM'.
> >
> > SELECT * FROM MyTable WHERE resourceType = 'PSM' --> returns nothing.
> >
> > SELECT * FROM MyTable WHERE resourceType like 'PSM' --> returns all PSM
> > entries.
> >
> > What's the diff?
> >
> > Thanks
> > _______________________________________________
> > 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
>
>
>
> _______________________________________________
> 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
