LIKE is case insensitive, while = is not.
-----Original Message-----
From: lizhu...@whaty.com
when I query :
select * from downloadVideo_table where sectionId =
'402814a34b823b23014bfc228fe9588c'
then I query the length of 'sectionId', it is 32.that is right.
select length(sectionId) from downloadVideo_table where site_code = 'jyzdy'
at last,
I query this:
select * from downloadVideo_table where sectionId like
'402814a34b823b23014bfc228fe9588c%'
or this:
select * from downloadVideo_table where sectionId like
'%402814a34b823b23014bfc228fe9588c'
I saw the data right.
it is so weird.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
