Comment by anthonyIPH
Comment by anthonyIPH 11 hours ago
"Instead you should:
query WHERE name = ‘abc’
create an indexed UPPER(name) column"
Should there be an "or" between these 2 points, or am I missing something? Why create an UPPER index column and not use it?
[and a third] OR use a case-insensitive collation for the name column.