Index a generated column

sql

ALTER TABLE users
  ADD COLUMN email_lc VARCHAR(255) GENERATED ALWAYS AS (LOWER(email)) STORED,
  ADD INDEX idx_users_email_lc (email_lc);

Explanation

A generated column can make case-normalized lookups indexable in MySQL.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing MySQL index patterns

Support a filter plus order-by pattern.

Open In sheetsqlsame section

Test an index without making it visible to the optimizer by default.

Open In sheetsqlsame section

Hide or re-enable an index without dropping it.

Open In sheetsqlsame section

See whether the optimizer chooses your index.

Open In sheetsql1 tag match

Help the optimizer make better choices after major data changes.

Open In sheetsql1 tag match

Diagnostic tool for checking alternate index paths.

Open In sheetsql1 tag match