Ecforu, Re: What's the diff?
In sqlite, LIKE without a "%" (percent-sign ) would be a case-insensitive search, whereas == would be case-sensitive. sqlite> select 'cat' like 'CAT'; 1 sqlite> select 'cat' == 'CAT'; 0 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users