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
