Apparently you must by typeing something wrong.
This works for me:
create table t(resourceType varchar);
insert into t values('PSM');
select * from t where resourceType = 'PSM';
PSM
select * from t where resourceType like 'PSM';
PSM
Does this work for you?
I'm using 3.6.23.1
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:22 AM
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
