James Server
  1. James Server
  2. JAMES-176

MySQL query not using index for string comparison

    Details

      Description

      MySQL SELECT string comparisions are already case-insensitive. Using lower() in a WHERE clause effectively negates the index.

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Serge Knystautas
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development