Sunday, March 18, 2018

Make Table Names and Column Names Case Insensitive in MySQL

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

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...