By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 5.7.33 |
create table x
(
y varchar (25),
z varchar (10) generated always as (left(y, 19)) stored, -- also virtual
key (z)
);
create table tab
(
id int(11),
name text,
primary key(id),
key name(name(10))
);