I would like to be able to query the table Users and its columns UserName and Email case insensitively:
select username, email from users;
I know MySQL is case-insensitive for strings by default--that is not my question. I would like to query case-insensitive table and column names.
The SQL Server environment I work allows me to do so but don't know how to do so in MySQL.
No comments:
Post a Comment