On Fri, Apr 30, 2010 at 9:22 AM, ecforu <ecforus...@gmail.com> wrote:
> 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 does this give you?
SELECT * FROM MyTable WHERE resourceType = 'PSM' COLLATE nocase;
> What's the diff?
>
> Thanks
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
---------------------
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
