Sunday, 18 March 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

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...