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

Reply via email to