| Key: |
JAMES-176
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
Serge Knystautas
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
| Resolution Date: |
21/Mar/04 10:50 PM
|
|
MySQL SELECT string comparisions are already case-insensitive. Using lower() in a WHERE clause effectively negates the index.
|
|
Description
|
MySQL SELECT string comparisions are already case-insensitive. Using lower() in a WHERE clause effectively negates the index. |
Show » |
|
MySQL query not using index for string comparison
