Bennet> MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
Bennet> http://www.mysql.com/doc/C/H/CHAR.html
Bennet> But I have a table with a column of type VARCHAR(255), and if I do a query
Bennet> like
Bennet> select * from user where LOCATE('Bennett', emailadd
Hi Bennett!
On Wed, 14 Nov 2001, Bennett wrote:
> I did try
> select * from user where 'Bennett' LIKE emailaddress;
>
> but it returned 0 results; in fact, so did
> select * from user where 'bennett' LIKE emailaddress;
I didn't think that through too well, did I. :) See the Doc for 'Pattern
Mat
MySQL documentation says that CHAR and VARCHAR types are case-insensitive:
http://www.mysql.com/doc/C/H/CHAR.html
But I have a table with a column of type VARCHAR(255), and if I do a query
like
select * from user where LOCATE('Bennett', emailaddress) > 0;
then the results are computed
